Link to home
Create AccountLog in
Avatar of goprasad
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.
Avatar of geek_vj
geek_vj

You cant migrate the system databases - instead u have to upgrade them.
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.
Avatar of goprasad

ASKER

How to go about scripting logins, jobs, linked servers, stored procedures (if any) to the new server? Please advise.
ASKER CERTIFIED SOLUTION
Avatar of Daniel_PL
Daniel_PL
Flag of Poland image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer