Failed to restore backup of msdb on a server with SQL Server version different from the version of SQL Server, in which the file was generated

Question

Failed to restore backup of msdb on a server with SQL Server version different from the version of SQL Server, in which the file was generated

Alantrix

SSC Enthusiast

Points: 168
More actions
November 29, 2011 at 12:08 pm

#263762

I am getting the following error when trying to restore a backup file from msdb:
Msg 3168, Level 16, State 1, Line 1
The backup of the system database on the device D:\Backup_Base_de_Dados\teste\teste_Full.BAK cannot be restored because it was created by a different version of the server (9.00.4035) than this server (9.00.5000).
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
Closer look at my surroundings (source / destination), I found that the two servers have SQL Server 2005 x64 with Service Pack 2, ie, differing only in the (Source: Standard Edition / Destination: Enterprise Edition).
>> Details about the version of SQL Server that the backup originated from msdb:
Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 16:17:31 2008 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
>> Details about the version of SQL Server I need to restore the backup of msdb:
Microsoft SQL Server 2005 - 9.00.5000.00 (X64) Dec 10 10:38:40 2010 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
Based on the above, what really makes it impossible to restore a backup of the database "msdb" in one instance with different version of the original instance?
a. Architecture: X86, X64, IA64?
b. Version: Standard, Enterprise, Express?
B. Service Pack?
C. Other combination?
I would be very grateful of you can answer me.
Looking forward.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

just guessing here, but i'm thinking you upgraded your server AFTER you created the backup, and system databases are restricted tot eh same version...client databases can be upgraded on the restore?

9.00.5000 is 2005 + SP4 RTM

9.00.4340 is 2005 SP3 + Q2494112

http://sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Richard Moore-400646 SSCrazy Points: 2384 More actions · Answer 2

The answer to your issue is B: The backup of the msdb system database is at an earlier revision than the current version i.e sp3.. to sp4.

Alantrix SSC Enthusiast Points: 168 More actions · Answer 3

Dear,

As I reported at the start of the topic, the two instances (source / target) are x64 and have service pack 2, with that, the only different from yours, is the version of SQL Server (Source: SQL Server SE / Target: SQL Server EE), thus, the question remains:

What really prevents restore of msdb?

Lowell SSC Guru Points: 323518 More actions · Answer 4

you pointed it out yourself, i think...the backup was created with SP3, but then SP4 was applied. the server is now SP4, but the backup's Sp3, and no longer compatible.

i'm pretty sure system databases cannot be restored from earlier versions(model.master,msdb)

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Alantrix SSC Enthusiast Points: 168 More actions · Answer 5

Once again I say that the two instances are the same service pack as we see below:

>> Details about the version of SQL Server that the backup originated from msdb:

>> Details about the version of SQL Server I need to restore the backup of msdb:

So we can say that the issue is the incompatibility of versions and not the service pack installed?

Lowell SSC Guru Points: 323518 More actions · Answer 6

operating system service pack does not enter into the equation.

SQL Server Service pack is the piece to look at.

Windows NT 5.2 (Build 3790: Service Pack 2)

that's the OS of both servers , but that's not relevant:

Microsoft SQL Server 2005 - 9.00.4035.00 vs.

Microsoft SQL Server 2005 - 9.00.5000.00

I threw a link out ther so you can track down which SQL Server Service pack or Cumulative update the version maps to.

the error message you originally posted is pretty clear on that:

Msg 3168, Level 16, State 1, Line 1
The backup of the system database on the device D:\Backup_Base_de_Dados\teste\teste_Full.BAK cannot be restored because it was created by a different version of the server (9.00.4035) than this server (9.00.5000).
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Alantrix SSC Enthusiast Points: 168 More actions · Answer 7

Lowell (11/29/2011)
operating system service pack does not enter into the equation.
SQL Server Service pack is the piece to look at.
Windows NT 5.2 (Build 3790: Service Pack 2)
that's the OS of both servers , but that's not relevant:
Microsoft SQL Server 2005 - 9.00.4035.00 vs.
Microsoft SQL Server 2005 - 9.00.5000.00
I threw a link out ther so you can track down which SQL Server Service pack or Cumulative update the version maps to.
the error message you originally posted is pretty clear on that:
Msg 3168, Level 16, State 1, Line 1
The backup of the system database on the device D:\Backup_Base_de_Dados\teste\teste_Full.BAK cannot be restored because it was created by a different version of the server (9.00.4035) than this server (9.00.5000).
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

Lowell,

Thanks.

Failed to restore backup of msdb on a server with SQL Server version different from the version of SQL Server, in which the file was generated

Cookies on SQLServerCentral