Home : Products : OPS SQL : Detach MS SQL Database
Q10025 - HOWTO: Detach MS SQL Database

You will need MS SQL Server administrator priviledges to perform tasks described in this document.

This example shows how to detach an OPS SQL facility database called OPSTEST.

  1. Make sure that there are no OPS SQL services running in the background. Stop them if they are. Click here to find out how to stop services.
  2. Run MS SQL Server Enterprise Manager
  3. Navigate to your database. Right click, go to All Tasks/Detach Database
  4. Click OK to detach DB.
  5. You will be notified that your database was detached.

    Click OK
  6. If you need to send this database to OPS SYSTEMS for support purposes, in Windows Explorer, navigate to folder where your database datafile was stored. The default installation puts MSSQL datafiles (.mdf) to C:\Program Files\Microsoft SQL Server\MSSQL\Data
    This may be different depending on what kind of storage unit your organization is using.
  7. Copy the .mdf file (in this case its OPSTEST.mdf) to a different location. Zip it up and upload it onto our support FTP server. Click here to find out how to use our FTP server.

In order to use the database again, you will need to attach it. Click here for instructions on how to attach a database.

 

 

Related Articles
Q10017 - HOWTO: Starting and Stopping Hach WIMS NT Services
Q10026 - HOWTO: Attach MS SQL Database

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 1/12/2004 9:40 AM.
Last Modified on 9/18/2007 5:34 PM.
Last Modified by No Author Name Available!.
Article has been viewed 7013 times.
Rated 1 out of 10 based on 7 votes.
Print Article
Email Article