up vote 5 down vote favorite
1
share [g+] share [fb]

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!

link|improve this question
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 '10 at 17:11
I just ran into this. Microsoft should be ashamed. – Rob Sobers Dec 8 '10 at 15:48
feedback

1 Answer

up vote 1 down vote accepted

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.

link|improve this answer
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 '10 at 19:55
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.