News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics SL (Archived) Help please.. Trying t...

Microsoft Dynamics SL (Archived)

Help please.. Trying to restore msdb database from SQL Server 2005 to SQL Server 2008 R2

(0) Share

Report

Report

Posted on by segun51

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

All responses Img

All responses (1)

Answers Img

Answers (0)

Community Member on at

Like (0)

Report

RE: Help please.. Trying to restore msdb database from SQL Server 2005 to SQL Server 2008 R2

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.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 293,245 Super User 2025 Season 1

#2

Martin Dráb 231,925 Most Valuable Professional

#3

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans