SQL 2000 Migration to New Servers

Question

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Nicholas Cain SSC-Dedicated Points: 33009 More actions · Answer 1

Have you considered log shipping?

It will put you easily within the window.

Match the logins and sids on the new machine.

Backup your existing databases.

Restore on the far side with no recovery.

Setup logshipping and ship the logs to the other side.

When you are ready to cutover perform a final log backup, restore it on the far side with recovery and you are done, apart from testing.

bsmith-540267 SSC Rookie Points: 29 More actions · Answer 2

Nicholas,

Thanks for the reply, I am not familiar with log shipping but I will review the info and setup a test, thanks for your help.

Bob Smith

Nicholas Cain SSC-Dedicated Points: 33009 More actions · Answer 3

Here's a pretty good Microsoft article as regards how to implement http://support.microsoft.com/kb/314515

Forgot to ask if you were running the Enterprise Edition of SQL 2000.

bsmith-540267 SSC Rookie Points: 29 More actions · Answer 4

Sorry for the late reply, it is SQL 2000 Standard.

Bob

Nicholas Cain SSC-Dedicated Points: 33009 More actions · Answer 5

Checkout this script from Adam Jorgensen to do a more manual version rather than the GUI version as the standard edition doesn't support it.

There are other scripts out there on the site as well, a search will provide some really good content to help you get started.

bsmith-540267 SSC Rookie Points: 29 More actions · Answer 6

Nicholas,

Thanks again will log shipping work even though SQL 2000 Standard

Thanks,

Bob