Windows Forum

Ask something
Discussion Locked

SQL Server 2000 database transfer

0 helpful
3 replies

by numbies

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need to transfer an SQL database from our old server to a new one and was wondering what the most reliable method of doing this is. I'm not sure what/if there are complications with the sa password in SQL 2000?

Any help would be most appreciated.

3 replies

by david.saszczak

You can do this a number of ways. The easiest way is to use the copy database wizard. Note doing it this way will require an AD account that starts the SQL service on both of the servers.
Another way is to backup the database and then restore it on the new server.

This discussion is closed to new replies.