Olson Technology OTOHP-NMS User Guide - Manual (Page 38)

Model OTOHP-NMS User Guide, Rev. X1 www.olsontech.com
38
ATTACHING A DATABASE FILE TO SQL SERVER
SQL Server 2000
1) In Enterprise Manager. Right click on the database and select “All Tasks” – “Attach database.”
2) The “Attach Database” screen pops up. Hit the ellipses button to search for the .mdf (primary data file) of the
database to attach. Once selected, all files belonging to the database will appear. Choose the name of the database to
attach as, specify the database owner then click the “OK” button. You will receive a notification that the database has
been attached successfully. Click “OK” to continue.
SQL Server 2005
1) Open the SQL Server Management Studio and connect to the desired server.
2) Right-click on “Databases” and select “Attach.”
3) Click the “Add” button and select the database file to be attached.
4) Click “Ok.”