Home : Products : OPS SQL : Attach MS SQL Database
Q10026 - HOWTO: Attach MS SQL Database

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

  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 Databases and right click on this item. Navigate to menu item Attach Database
  4. Attach Database menu will pop up. Click on the the dots button (...) to browse to the .mdf file that you need to attach.
    The default configuration puts the .mdf files to C:\Program Files\Microsoft SQL Server\MSSQL\Data
    This may be different depending on what kind of storage unit your organization is using.

    Select the file and click OK
  5. You will be back to the Attach Database window

    Please note that the LDF file does not need to exist. MS SQL Server will create a brand new log file if it cannot find one that exists. Hence your window can also look like the following :

  6. Make sure that the Specify database owner field is set to OPSDBA
  7. Click OK. A message about the logfile being incorrect may come up that looks like the following :

    Click YES to continue.
  8. A confirmation message will be shown.
  9. You should now be able to see the attached database in Enterprise Manager.

  10. Make sure that your OPS SQL services are running. See http://www.opssys.com/instantkb/article.aspx?id=10017
Related Articles
Q10017 - HOWTO: Starting and Stopping Hach WIMS NT Services
Q10025 - HOWTO: Detach 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?


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