Issue
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)
Product
Struxureware Power Monitoring
Power Monitoring Expert
ION Enterprise
ION EEM
Environment
SQL Server 2005, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014
Cause
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.
Resolution
The suggested workarounds to this problem include:
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)
Product
Struxureware Power Monitoring
Power Monitoring Expert
ION Enterprise
ION EEM
Environment
SQL Server 2005, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014
Cause
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.
Resolution
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.
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.