Click here to Skip to main content
15,922,155 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
if i have create backup for Microsoft SQL Server 2008 R1 from Microsoft SQL Server 2008 R2? Can i only convert a bak file? Please do not provide a solution to create a script.


No, In this particular case, SQL Server Management Studio is telling me that when SQL Server attempted to restore the backup, it realized that the backup was from SQL Server 2008R2 but I was restoring to SQL Server 2008. As a result, the restore failed.

You can’t restore a backup from a newer version of SQL Server to an older one.  Attach and detach will also fail.
Share this answer
No. If you cretae a "proper backup" file for R2, then you can't restore it to R1 - you can go the other way, but you can't "downgrade" the data as R1 doesn't know anything about R2 (understandably)

So despite this: "Please do not provide a solution to create a script." I'm going to: your only option is to create a script.
Share this answer
Only way is to create scripts (you can create script for 2008 or older version). During the generation of scripts you can choose between only schema, schema+data, only data...
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900