SQL Upgrade.... 1

[mrchris]

Hi guys,

Currently have SQL 2000 running on an NT 4.0 box. We want to upgrade to a new server running the same version of SQL but new hardware and running windows 2003 server. What would be the best approach to this?

Thanks

 

[Corran007]

since your not upgrading sql, its really easy, unless you made modificaitons to master which you can proaby rescript, then it becomes a bit more difficult.

Set up sql server to same patch level as the current one(even if not the most recent)

Transfer users,I believe you can restore the msdb database on the new one (reason for same patch level). Retstore model if you have modified it any. just either backup and restore databases on the new one or detach, copy and reattach the user databases. Id use backup and restore if your not comforatable with detaching databases.

Patch up sql to lastest sp or patch depending on how your company does it.

Thats about it. If you have any replication with the server, you will need to make sure they are set up again correctly.

 

[Corran007]

Just realized when reading this i may not have been clear.

Transfer users,I believe you can restore the msdb database on the new one (reason for same patch level).

That is two seperate things. You transfer users, then you do the restore of msdb.

It sure feels like a monday