Networks

Ask something
Discussion Locked

SQL 2000 DB copy

0 helpful
1 reply

by steelhector

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is there another option besides using the Copy db wizard in SQL 2000 eng ? What would be the quickest and best possible way to insure a copy of a large SQL 2000 database, and relocate it on a different SQL 2000 server?

1 reply

by hpw3

I'm not sure if either of these would be quicker than a DB copy but I have had success with both:

1. If you set up a SQL job to copy a DB backup overnight to the new server then do a restore with that backup to a new database.

2. You can alsoset up a DTS job to run overnight to do an import to the new database. You will probably want to choose the 3rd option "Copy ojects and data between SQL server databases".

This discussion is closed to new replies.