Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 275
  • Last Modified:

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.
0
goprasad
Asked:
goprasad
1 Solution
 
geek_vjCommented:
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.
0
 
goprasadAuthor Commented:
How to go about scripting logins, jobs, linked servers, stored procedures (if any) to the new server? Please advise.
0
 
Daniel_PLDB Expert/ArchitectCommented:
To script logins please read following articles
http://support.microsoft.com/default.aspx?scid=kb;en-us;246133
http://www.databasejournal.com/features/mssql/article.php/2228611/Migrating-Logins-from-One-SQL-Server-to-Another.htm
http://www.windowsitpro.com/article/query-analyser/sql-server-login-transfer.aspx

To get jobs I would suggest you to run SSMS (SQL Server Management Studio) aonnect to SQL Server 2000 database server and select all jobs in SQL Server Agent node. Next righ click and choose Script Job as Create to ...
You can also use DTS and use Transfer Jobs task.
0

Featured Post

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now