63,630 pts.
POSTED: Feb 17, 2009 3:38 PM (GMT)
Thanks, what would be the best way to move the data over after I get the database moved over
How to move the msdb database to sql 2005
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
UPDATED:
February 17, 2009 3:38:43 PM GMT
RELATED QUESTIONS
- How do I move all stored procedures to a new SQL server?
- How do you recover SQL Server from a detached msdb database?
- SQL Server 2005 Reporting Services Move
- Error when upgrading SQL Server 2000 to SQL Server 2005
- How do you set a SQL Server job step status?
- Adding a password to a SQL Server 2005 database
- Failed ODBC USER DSN connection to SQL Server 2005
- SQL Database User
- How do I connect SQL Server 2005(mobile edition) to Visual Studio 2005?
- Question about Crystal Reports
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.
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.
To see other answers submitted to the Answer Wiki View Answer History.
