CODEWITHSUNDEEP
asp.netsql-serversql-server-2008
Ayyappan Sekaran
Ayyappan Sekaran

Reputation: 1036

Not able to restore SQL Server 2008 R2 database

Database backup from SQL Server 2008 R2 only. My system also has SQL Server 2008 R2 installed. On restoring that database it throws error:

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.

What's the reason for this error. Please I need a solution

Upvotes: 0

Views: 1007

Answers (2)

Iswanto San
Iswanto San

Reputation: 18569

Your backup source is created using sql server version 10.50.1600, but your server is 10.00.1600 and like the error message said there is incompatible.

It is not possible to downgrade a database. Possible solutions is to upgrade your instance from 10.00.1600 to 10.50.1600.

If you're using SQL Express, you can download from here.

Upvotes: 0

Remus Rusanu
Remus Rusanu

Reputation: 294177

You are wrong about the system you have. The error message clearly states that the current version is 10.00.1600, which is SQL Server 2008 RTM. Your backup is indeed from a SQL Server 2008 R2. You will only be able to restore that backup on an SQL Server 2008 R2.

Do not confuse the version of the tools (Management Studio) with the version of the SQL Server instance.

Upvotes: 1

Related Questions