Sql-server – Can’t restore backup from SQL Server 2008 R2 to SQL Server 2005 or 2008

sql serversql-server-2008

I'm trying to get a backup from SQL Server 2008 R2 restored to SQL Server 2008, but when we try to do the restore we get this:

The database was backed up on a server running version 10.50.1092. 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.

I can use the script wizard to generate a script, but that takes over an hour to run. I also tried just exporting the data from server to server, but it had issues with the primary keys/identity columns. I will be running into this issue with several other clients so any help you could offer about how to get around this would be great.

Thanks for your help!

Best Answer

You're pretty much stuck with scripting. Databases travel up the chain easily but you can't go back a version in the same way.