SQL Server Performance Forum – Threads Archive

Restore msdb

How can I restore msdb on sql 2005 server. I have a backup created on a sql 2000 machine. I need this database to recreate all jobs that I have in the sql 2000 server. Please help.

As far I know you can’t do that.
Check: http://sqlserver-qa.net/blogs/tools…-upgrades-of-your-sql-server-environment.aspx
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19622
http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

You can’t restore system databases from one build/version to another… You have script the jobs, operators and alerts and run the script on 2005.
If you have dts packages you can migrate if there are strait dts without any ActiveX script and/or additional mapping…otherwise it is better to create new SSIS packages…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>