CODEWITHSUNDEEP
sqlsql-serversql-server-2008
Sarim421
Sarim421

Reputation: 141

Restoring database through SQL Management studio

I have a .bak file that I am restoring but SSMS gives an error that is

"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)"

I have updated SSMS, now its version is 10.50.4000. But the problem is still the same.

Upvotes: 1

Views: 6536

Answers (1)

Giannis Paraskevopoulos
Giannis Paraskevopoulos

Reputation: 18431

You may not restore a backup of a higher version of SQL to a lower version of SQL.

Have a look at sql server builds.

10.50.1600 is SQL Server 2008 R2 while 10.00.1600 is SQL Server 2008.

Updating SSMS is not going to work, as it is only a Client Tool, and not the Server itself.

You need to upgrade the Server engine in order for the upgrade to work.

To see this is true, you may open your newly upgraded SSMS and login to the server where you want to restore your backup. In the tree you will see the Server's version in a parenthesis next to the Server's name. You will notice that though you upgrader SSMS, the Server's version remains the same.

Upvotes: 2

Related Questions