How to move the msdb database to sql 2005
Home > IT Answers > Database > How to move the msdb database to sql 2005
Bubbanm
90 pts.
0
Q:
How to move the msdb database to sql 2005
SQL database replication, SQL Server MSDB Database, SQL 2005, SQL 7
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.
ASKED: Feb 16 2009  2:30 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46810 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 Answered: Feb 16 2009  10:05 PM GMT by Mrdenny   46810 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Bubbanm   90 pts.  |   Feb 17 2009  3:38PM GMT

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

 
0