{}

Our Brands

Impact-Company-Logo-English Black-01-177x54

Welcome to the Schneider Electric Website

Welcome to our website.
Search FAQs
Unable to Restore System Databases Backup Due to Version Mismatch
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:
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.

Schneider Electric Canada

Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.