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
Microsoft SQL Server
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:
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.
Released for:Schneider Electric Canada
