goprasad
asked on
Migrate SQL 2000 System DB's
Hello experts,
I have an old DL 320 server hosting SQL 2000 edition and W2K3 Std OS. We are migrating to a new BL server with W2K8 Std 32 bit OS and SQL 2005 STD edition.
How do I go about migrating System Databses (Master, MSDB and Model) to this new box.
Please advise.
Thanks and Regards.
I have an old DL 320 server hosting SQL 2000 edition and W2K3 Std OS. We are migrating to a new BL server with W2K8 Std 32 bit OS and SQL 2005 STD edition.
How do I go about migrating System Databses (Master, MSDB and Model) to this new box.
Please advise.
Thanks and Regards.
ASKER
How to go about scripting logins, jobs, linked servers, stored procedures (if any) to the new server? Please advise.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
As it is upgraded on a different system, then you have to script the logins, jobs, linked servers, stored procedures (if any) to the new server.