April 20, 2006 at 2:35 pm
We're planning on replacing the server that runs SQL 2000. The systems dabatases are on internal drives, and the other databases are on external storage. Does anyone know of a good document listing do's and don'ts for a server swap ? I'd also like to change the default collation for SQL while I'm at it if possible.
Any advice is appreciated. Thanks
April 20, 2006 at 3:43 pm
In a nutshell, it is pretty straight forward. I have done three dozen at least.
Here are a few tips:
Make sure, 3 times over, your build version is exactly the same on both old and new boxes. http://www.aspfaq.com/sql2000builds.asp Get this wrong and it's over before it began.
Once you back up, for heaven sakes dont make any changes to the Master, Model or MSDB databases. This means you can't change the default collation.
Assuming you have installed SQL 2000 on the new box, got the builds exactly right, (same), you can log in - in single user mode as SA - open up a QA session and restore your Master, Model and MSDB databases in that order.
Reboot like things are normal.
Restore your other backups using QA or EM.
Hopefully you have scripts of your users, if not script them out. You can run the script on the new box at this point.
If the machine is involved in replication, its just a little more challenging but not much.
That's the short version. You can find great details all over this site.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply