How do I detach a database when using 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 detach a database that is currently not in use. Detaching a database removes it from the instance of the Microsoft SQL Server Database Engine but leaves intact the database, with its data files and transaction log files. These files can then be used to attach the database to any instance of SQL Server, including the server from which the database was detached. You cannot detach a database if any of the following are true:

• The database is replicated and published. If replicated, the database must be unpublished.
  
  
• A database snapshot exists on the database.
  
  
• The database is being mirrored in a database mirroring session. The database cannot be detached unless the session is terminated.

Note: After detaching a SQL Server database, you can reattach it to the same or another instance of SQL Server. For more information, see Attach a Database.

Solution:

To detach a database

1. Connect to an instance of the Microsoft SQL Server Database Engine in the SQL Server Management Studio Object Explorer.
   
   
2. Expand the instance.
   
   
3. Expand Databases and select the name of the user database that you want to detach.
   
   Note: Detaching a database requires exclusive access to the database. If the database is in use, restrict access to a single user.
   
   
4. Right-click database name and click Tasks, Detach.
   
   The Detach Database dialog opens with the name of the selected database in the Database Name column of the Databases to detach grid.
   
   
5. Verify the selected database is that you want to detach.
   
   
6. Click the Update Statistics check box.
   
   The existing optimization statistics is updated.
   
   Note: By default, the detach operation retains any out-of-date optimization statistics when detaching the database.
   
   
7. Clear the Keep Full-Text Catalogs check box.
   
   The full-text catalogs that are associated with a database is removed.
   
   Note: By default, the detach operation keeps any full-text catalogs that are associated with the database.
   
   
8. Select the Drop Connections check box.
   
   All the active connections are disconnected.
   
   Note: The Status column displays the current database state (either Ready or Not Ready).
   
   
   • The Message column displays information about the database in a hyperlink, if the status is Not Ready. Click the hyperlink, to obtain more information about a message.
     
     
   • The Message column displays Database replicated, when a database is involved with replication.
     
     
   • The Message column displays <number_of_active_connections> Active connections, when a database has one or more active connections.
     
     
9. Click OK.
   
   
   The database is now detached.
   
   
   Note: The newly detached database will remain visible in the Databases node of Object Explorer until the view is refreshed. You can refresh the view at any time.

After detaching the CASRMCentralDB, copy the CASRMCentralDB MDF, LDF files from the default location and paste them into another partition where we have more space allocated.

Example:

Copy the mdf and ldf files from default location C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\CASRMCentralDB.mdf to D:\SQLDataFiles

Environment

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