Monday, March 12, 2012

How to fix Error 'Restore failed for Server 'SQLSERVER'

-->
Backup & restore are the most important task of any database administrator. A good backup & restore plan will help you to save your valuable data as well as business. If you have not maintained backup of your database and suddenly disaster occurs on the database then you will be in nightmare situation. If you are working for a company then you may loose your job also; therefore always maintain and update your backup properly.

Consider a scenario wherein you have two server, server A & server B and both the servers have SQL server version 10.50.1600. You have taken the backup of your data & log file from server A and trying to restore on server B but got following error message

TITLE: Microsoft SQL Server Management Studio

Restore failed for Server 'SQLSERVER'. (Microsoft.SqlServer.SmoExtended)

ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.1600. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.Smo)

Cause: The most possible cause for above error message is that your destination server (server B) may have connected to lower version of SQL server as compared to source server (server A).

Note: Restoring a SQL server Database from lower version to higher version or same version would not give error message but restoring from higher to lower version will always result error message.

How to Fix: To fix above error message, you will have to perform below steps.

  • First of all open SQL query window
  • Run “Select @@Version” command
  • See the Output of command
  • Match current version of server B with old connected server
  • If versions are different for both servers then update the version of old connected server
  • Now perform restore operation
  • Successfully done

No comments:

Post a Comment