6

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!

2
  • 1
    Have a look at my answer here: serverfault.com/questions/62070/… as well as the link in the comment to my answer. Scripting is pretty much it. RedGate's SQL Compare and SQL Data Compare but be able to get you farther, though.
    – squillman
    Jun 8, 2010 at 17:11
  • I just ran into this. Microsoft should be ashamed.
    – Rob Sobers
    Dec 8, 2010 at 15:48

1 Answer 1

1

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.

1
  • Yep, it looks like scripting is the only way. I was hoping to only have to have one SQL Server running, but it looks like I'll have to run side by side versions.
    – Erick
    Jun 11, 2010 at 19:55

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .