Can't restore backup from SQL Server 2008 R2 to SQL Server 2005 or 2008

Posted by Erick on Server Fault See other posts from Server Fault or by Erick
Published on 2010-06-08T17:04:19Z Indexed on 2010/06/08 17:12 UTC
Read the original article Hit count: 764

Filed under:
|

Hi everyone, 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!

© Server Fault or respective owner

Related posts about sql-server

Related posts about sql-server-2008