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
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
Need help?
Product Selector
Quickly and easily find the right products and accessories for your applications.
Get a Quote
Start your sales inquiry online and en expert will connect with you.
Where to buy?
Easily find the nearest Schneider Electric distributor in your location.
Help Center
Find support resources for all your needs, in one place.