You’re offline. This is a read only version of the page.
30
After changing Compatibility level to SQL Server 2005 (90) in the 2008 R2 environment.
I backed up the msdb database and copied it over to the SQL Server 2008 R2 environment.
But wile trying to restore using the GUI and in options, choosing the "Overwrite the existing database (WIT REPLACE). Getting the below error :
The backup set holds a backup of a database other than the existing 'msdb' database.
RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3154).
Any assistance would be greatly appreciated.
*This post is locked for comments
I have the same question (0)
Perhaps I am missing something here but why are you trying to backup the MSDB database and restore it to another SQL server? MSDB is a system database containing pertinent SQL Server information but has nothing to do with Dynamics SL. Since this is a Dynamics SL forum I am thinking you are trying to move SL databases to the new server and you do not need to move the MSDB database to do that.
Share
Report
All responses (
Answers (
