Home > IT Answers > SQL Server > How to move the msdb database to sql 2005
Bubbanm
90 pts.
 How to move the msdb database to sql 2005
SQL 2005, SQL 7, SQL database replication, SQL Server MSDB Database
I have a server running sql 7.0 and I need to move the msdb database to another server running sql 2005. When I try to restore the db from a backup I'm getting a compatability error message. Any suggestions greatly appreciated.

Software/Hardware used:
ASKED: February 16, 2009  2:30 PM
UPDATED: February 17, 2009  3:38 PM
RELATED QUESTIONS
Answer Wiki:
You won't be able to restore a system database over a system database of a different version of SQL server. You'll need to restore the database to a different name, then move the data into the tables you need to move it in to in the MSDB database. I assume that you are trying to move the jobs over? The DTS packages won't move over as the DTS package format changed from SQL 7 to SQL 2000.
Last Wiki Answer Submitted:  February 16, 2009  10:05 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Thanks, what would be the best way to move the data over after I get the database moved over

Bubbanm
 90 pts.