Categories
Sql Server

The database was backed up on a server running version 10.50.1600. version is incompatible with this server

The database was backed up on a server running version 10.50.1600. version is incompatible with this server

When your try to restore a database which backup is taken on Sql server 2008 R2, and you will try to restore backup of that database in below version then sql server 2008 R2 then you will get this Error message.

——————————————————————————————

TITLE: Microsoft SQL Server Management Studio

Restore failed for Server ‘MANN’.  (Microsoft.SqlServer.SmoExtended)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1447.4+((KJ_RTM).100213-0103+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

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)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1447.4+((KJ_RTM).100213-0103+)&LinkId=20476

———————————————————————————————

database_restore_errorclick on image to enlarge.

 

 

To overcome this error try Out this steps:-

Download the Latest service pack for your sql server if you are using sql server 2008.

Install it and problem is fixed.

Download it from here

If you are using sql server 2000 or sql server 2005 then download sql server 2008 R2 express for free from here