Unable to restore MDSB database

• Ryan007

  SSCrazy Eights

  Points: 8275

  More actions

  January 27, 2012 at 1:18 am

  #267331

  Hi,

  I took backup of MSDB database and the applied SP4. Now while restoring the database it gives the below error. What is the workaround to overcome this issue?

  Msg 3168, Level 16, State 1, Line 1

  The backup of the system database on the device D:\Backups and scripts-26 Jan12\msdb.bak cannot be restored because it was created by a different version of the server (9.00.3042) than this server (9.00.5000).

  Msg 3013, Level 16, State 1, Line 1

  RESTORE DATABASE is terminating abnormally.

  Ryan
  //All our dreams can come true, if we have the courage to pursue them//

• umasingh

  Ten Centuries

  Points: 1182

  More actions

  January 27, 2012 at 1:35 am

  #1439186

  Check this.

  http://www.sqlservercentral.com/Forums/Topic1213478-392-1.aspx

  http://support.microsoft.com/kb/264474