Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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!

share|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

1 Answer 1

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.

share|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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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