How do I attach a database for Web Reporter?

Products

• Activator
• eTrust ALERT
• eTrust ALERT for CICS
• ALERT
• Archiver
• ASM/ARCHIVE VSE-ESA OPTION
• ASM/Archive
• AutoAction
• AutoSys Job Management Adapter for AutoXfer
• Process Automation Manager
• Portal
• ARCserve Backup Client
• CICSORT
• Clipper
• COBOLVISION Analyzer
• CTO Distributed
• Dart
• Datesolver/2000
• Distribulink
• EUREKA:Object
• EPIC VM
• Enterprise
• Endevor for Unix
• Archiver Disk Option
• EPIC Backup
• EPIC Access Option
• EPIC SUPER SYS
• EPIC for CMS System
• EPIC TAPE MANAGEMENT
• eTrust Antivirus Gateway for CVP
• eTrust Content Inspection Gateway
• eTrust Content Inspection Gateway Option for MSP/ISA EE
• eTrust Antivirus Gateway for Netscape
• eTrust VPN Enterprise Edition
• FAQS VM
• FAQS Automated Systems Operation
• Global Subsystem (GSS)
• ANDYNE
• MAINFRAME MISCELLANEOUS
• Inventory Discovery Server
• ARS Resource Management
• JARS Resource Management ACC Option
• JOBDOC
• JOBWATCH
• Look
• MAZDAMON
• Service Management Affiliate Technology Partner Fee
• Service Management Basic Technology Partner Fee
• Metanet
• MF - MISC OLD CODES
• Omniguard for CICS
• Omniguard
• Opera
• Connect
• PREVAIL
• Paramount XP CAM FOR DIST SYS
• Paramount FOR NAVIGRAPH/HOST
• Research Planmacs Unlimited
• Project Planner
• Remote Console PREVAIL/XP-AUTOMATION PHASE 1
• Remote Console PREVAIL/XP AUTOMATION-RDF/SSM
• Raps
• Research Raveler
• Generic Non Product
• SOLVE:EPS
• Unicenter NetMaster Network Management for SNA
• Alexandria
• Sort System
• SPOOLMAN
• Storage Mainframe
• SYSTEM/SCHEDULER
• SYSTEM/SCHEDULER VSE-ESA OPTION
• System/Manager
• Tape/Manager VSE-ESA OPTION
• Output Management Document Server
• TNG Network and Systems Management Agent for CA-Datacom
• DFSMShsm Workstation
• Network and Systems Management UNIX SMTP
• Unicenter Management for Microsoft Exchange SMTP Option
• UNICENTER II
• Unicenter Network and Systems Management Database Performance Monitor Option
• UNICENTER OSM
• Database Command Center Mnt
• VM:DBA
• VM:DB Admin
• VM:DB Center
• VM:DB Developer
• VM:DB Editor
• VM:DB Monitor
• VM:DB Reorganizer
• VM:DB Reporter
• VM:DB Restore
• VM:DB REXX
• VM:DB SQLMAP
• VM:DB Suite
• VM:Migrate
• VM:Monitor
• VM:Notekeeper
• V/Solver
• VM:Webserver for Officevision
• VM:Webserver Secure
• VM:Webgateway
• VM:Webserver
• XMENU for z/VM
• VISION:COMBO for TSO
• VISION:DAGER
• VISION:ELEVEN
• VISION:EIGHTY
• VISION:Online
• VISION:IQ for Informix
• Automate
• STORAGE RESOURCE MANAGEMENT SUITE

Issue/Introduction

Description:

You can attach a copied or detached SQL Server database. When you attach a SQL Server database that contains full-text catalog files onto a SQL Server server instance, the catalog files are attached from their previous location along with the other database files.

After detaching a SQL Server database, you can reattach it to the same or another instance of SQL Server. Attaching a database places it in exactly the same state that it was in when it was detached.

Note: We recommend that you do not attach or restore databases from unknown or untrusted sources.

Solution:

To attach a database:

1. Connect to an instance of the Microsoft SQL Server Database Engine in SQL Server Management Studio Object Explorer.
   
   
2. Expand the instance.
   
   
3. Right-click Databases and click Attach.
   The Attach Databases dialog opens.
   
   
4. Click Add.
   The specified database is attached.
   
   
5. Select the disk drive where the database resides in the Locate Database Files dialog.
   
   
6. Expand the directory tree to find and select the .mdf file of the database.
   
   
• Example:
  D:\SQLDataFiles\CASRMCentralDB.mdf
  Important! Trying to select a database that is already attached generates an error.
  
  
7. Enter the name in the Attach as column of the Attach Databases dialog.
   A different name is specified for the database.
   
   
8. Select a different entry in the Owner column.
   The owner of the database is changed.
   
   
9. Click OK.
   The database is now reattached.
   Note: A newly attached database is not displayed in the Databases node of Object Explorer until the view is refreshed. You can refresh the view at any time.

Environment

Release: BRMAPS20100-11.7-Storage Resource Manager-Application Server
Component: