Redirected restore of SharePoint or SQL Server fails with - An error occurred on a query to database msdb

  • Article ID:100006819
  • Modified Date:
  • Product(s):

Problem

Restore of SharePoint or SQL Server fails when the SQL Server version is different than the one used when the backup job was performed.

 

 

 

Error Message

0xe0008492 - Database Query Failure

V-79-65323-3168 - An error ocurred on a query to database msdb.

V-79-65323-3169 - The backup of the system database on the device XX_XXXxxxx_XXXX cannot be restored because it was created by a different version of the server (X.XX.XXXX) than this server (X.XX.XXXX)

Note: X.XX.XXXX stands for SQL Server Version

Example: 9.00.5000 (SQL Server 2005 SP4)
 

Cause

 When restoring a backup of a system database (master, model, or msdb) on a server build that is different from the build on which the backup was originally performed causes the restore job to fail, with the error message mentioned.


 

Solution

Per Microsoft's support guidelines, a restore from a backup of a system database (master, model, or msdb) on a server build that is different from the build on which the backup was originally performed.

A possible workaround is available in the following Microsoft KB article:
http://support.microsoft.com/kb/264474

 

 

 

 

Was this content helpful?

Get Support