Technical FAQs

Ask a Question

Unable to Restore System Databases Backup Due to Version Mismatch

When restoring a System database (Master, Model or MSDB) the following error is returned:
System.Data.SqlClient.SqlError: The backup of the system database on the device D:\msdb\msdb_backup.bak
cannot be restored because it was created by a different version of the server (10.50.2550) than this server (10.50.6000). (Microsoft.SqlServer.Smo)

Struxureware Power Monitoring
Power Monitoring Expert
ION Enterprise

SQL Server 2005, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014

This error occurs because, SQL does not allowed a restore of a System database using backup file of the same System
database when the backup was performed using a different version. 
This problem is only specific to System databases, and not for User databases.

The suggested workarounds to this problem include:
1) Bring the SQL Server instance on to same version as that of the backup file, so that you could perform the system database restore.
2) Restore the System databases on another test server which has the same SQL Server version and then extract the required data and create the same on which ever server required.
3) Attempt to restore the database as a User database and then extract the required data from it.
Was this helpful?
What can we do to improve the information ?