Error in restoring .bak file to SQL Server 2008

2
votes

I am trying to restore a backup file to SQL Server 2008. I am getting the following message.

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 need to transfer all data from the SQL server 2008 R2 backup file to SQL server 2008 database.

Can you please suggest me how to restore the .bak file.

1
sql-serversql-server-2008sql-server-2008-r2
What don't you understand in the error message? – Mat
I tried to but was not clear about SQL Server 2008 and R2. – Harsh
You CANNOT restore a database backup made on a newer version of SQL Server (2008 R2 - v10.50) in an older version of SQL Server (like 2008 = v10.00). This is not (and never has been) supported. – marc_s

1 Answers

4
votes

Although SQL 2008 and SQL2008 R2 have similar(ish) names, a backup from SQL 2008R2 (where your .bak file was created) cannot be restored on a SQL 2008 instance (where you are trying to restore it.)

You could create a new backup using a third party tool like Redgate SQLBackup, or you could use the import/export wizard in SSMS to transfer the data, but R2 backups are not backward compatible unfortunately.