0

Possible Duplicate:
SQL Server database backup restore on lower version

I use SQL Server 2008 locally, and on the production server my database is SQL Server 2008 R2.

For a quick test, I would need running RESTORE TASK to my local DB with a backup from the production server.

I receive this error:

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.2531.
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 understand versions are different, but I would like to know if exist a quick work around (better called a quick HACK).

Community
  • 1
  • 1
GibboK
  • 71,848
  • 143
  • 435
  • 658
  • See http://stackoverflow.com/questions/6183139/sql-server-database-backup-restore-on-lower-version – Luke Girvin Nov 16 '11 at 12:40
  • This has been asked (and answered!) a great many times, and the answer still is: **NO** this is **NOT** possible, and **NO**, there's no magic "fix" to make this work. It just cannot be done. You either need to be on the same version (e.g. install SQL Server 2008 **R2** Express locally), or you need to use some structure/data scripting tools to go from a newer version back down to an older version. – marc_s Nov 16 '11 at 13:15
  • Thanks guys for the link, I did not realize when I was posting that the questions was already asked, sorry about that. – GibboK Nov 16 '11 at 13:23

0 Answers0