Unable Restore data to MSSQL 2008 SP2 from MSSQL 2008 R2 - by LeungKing

Status : 

  Not Reproducible<br /><br />
		The product team could not reproduce this item with the description and steps provided.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 615515 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 10/21/2010 12:38:17 AM
Access Restriction Public


I know that we cannot restore a laster SQL version data to a previous SQL version, however, do we have any alternative method to do so like a conversion tool or SP3 etc...
I have downloaded 2008 SP2 and installed it on SQL server 2008 , but the result as same.
Error message called : "The database was backed up on a server running version 10.50.1600. 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 have tried to use script out all data method and run those scripts on SQL server 2008, however, it has some tables corrupted.
Any idea regarding this issue. Thanks.
Sign in to post a comment.
Posted by Microsoft on 11/11/2010 at 12:41 PM

Thanks for contacting Microsoft. Your feedback is valuable. Your observation that we cannot restore a laster SQL version data to a previous SQL version, is correct. Your workaround seems to be a reasonable solution. We tried reproducing this scenario, but could not hit your issue.

It would be great if you could give us your sample database (which you say gets corrupted), and the exact repro steps that you carried out. This could help us in debugging this forward.

Thanks again for contacting Microsoft.