General discussion


migrate SQL from one server to another

By Friscojw ·
what are the steps required for moving a sql db from an old server to a new box?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by EGV In reply to migrate SQL from one serv ...

Like most technical questions, the answer will vary based on a number of issues. If all things are equal, ie the SQL versions are the same (SQL 7 or SQL 2000) and the backup devices are compatible, it is as simple as doing a full SQL backup from the old server and restoring it to the new server. If restoring the file groups to their original location, ensure the drives and folders exist, or you can modify the paths for each filegroup in the restore options tab (when using Enterprise Manager). You will need to check user security settings to allow access to the DB on the new server. Check for "orphaned users" in the new DB - these are user logins that had access on the old server but no longer exist on the new server.
This is a very basic overview that works when moving a DB from SQL 7 to SQL 2000 as well, but cannot be used for SQL 6.5 DB's.
Another point to consider is how client applications get their connections to the data. If the new server name is different, this may cause further complications and may require a more in depth plan, for both the servers and clients, to move the DB.
The microsoft support web site has a lot of good documentation on how to do this. Search for articles on upgrading to SQL 2000.

Collapse -

by Friscojw In reply to migrate SQL from one serv ...

This question was closed by the author

Related Discussions

Related Forums