备份MSSQL R2 for R1 [英] Backup MSSQL R2 for R1

问题描述

如果我从Microsoft SQL Server 2008 R2创建Microsoft SQL Server 2008 R1的备份？我可以只转换一个bak文件吗？请不要提供创建脚本的解决方案。



谢谢！

Hi,
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.

Thanks!

推荐答案

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.

否。如果您为R2创建了正确的备份文件，那么您无法将其恢复到R1 - 您可以采用其他方式，但您不能降级数据，因为R1对R2不了解（可以理解） ）



尽管如此：请不要提供创建脚本的解决方案。我要去：你唯一的选择是创建一个脚本。

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.

唯一的方法是创建脚本（你可以创建2008或更早版本的脚本）。在生成脚本期间，您可以只选择模式，模式+数据，只选择数据......

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

这篇关于备份MSSQL R2 for R1的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！