Moving an MS SQL database to another PC or laptop

NETKEEPER^{^{^�}}
nklin1.gif (3727 bytes)
|Home|Products|Demos|Tech Support|Top FAQ list| Help Desk Software| CRM Software|

Moving an MS SQL database to another PC or laptop
Document ID : 000-000643 Created: 6/27/2001 Last changed on: 6/27/2001

To move the database to another PC or laptop

*- Backup the database
*- Open Enterprise manager, rightmouse on the database name and select PROPERTIES
*- Record the filename and location for the database, example : c:\mssql7\data\NetKeeper_data.mdf
*- Disable replication on the server, this should also delete all the publications and articles.
*- Open query analyzer select the server and use the "master" database
*- Check that no one else is using the database and close enterprise manager
*- Detach the NetKeeper database using the following query:
sp_detach_db 'NetKeeper'
*- Copy the database file (example: c:\mssql7\data\NetKeeper_data.mdf) to a temporary directory.
This file contains the entire NetKeeper database and is a very good backup.
*- Re-attach the database to the server by running the following query:
sp_attach_db 'NetKeeper', 'c:\mssql7\data\NetKeeper_data.mdf'
Note: substitute the correct name and path for your file in the above statement
*- Check that the dabase is now available in enterprise manager

On the laptop:
*- Install SQL7 at the same SP level as on the server
*- Do not enable replication, delete if necessary
*- Copy the NetKeeper_data.mdf (substitute your file name) to the c:\mssql7\data folder (or whichever
data folder is used by the laptop's MS SQL Server)
*- Open query analyzer and attach the database
sp_attach_db 'NetKeeper', 'c:\mssql7\data\NetKeeper_data.mdf'
Note: substitute the correct name and path for your file in the above statement
*- Open enterprise manager and check that the database is available.
* Start NetKeeper and verify operation and login setup.

Note: Once the copy is made you can re-enable replication as needed.

This solution text WEB page is automatically generated from your knowledge base and service data by NetKeeper Help Desk Software or NetKeeper CRM software. You can customize the pages to your site's look and feel or even include advertisements.