如何使用 .bak 文件将数据从 MS SQL 2012 恢复到 MS SQL 2008.这可能吗? [英] How to Restore data from MS SQL 2012 to MS SQL 2008 using .bak file. Is this Possible?

问题描述

我有一个遇到困难的要求，即使用 .bak 文件将数据从 MS SQL 2012 恢复到 MS SQL 2008.当我尝试恢复时，出现错误.是否有可能将其恢复为降级.

I have a requirement that am facing difficulty i.e. restoring a data from MS SQL 2012 to MS SQL 2008 using .bak file. when am trying to restore , am getting an error. is this possibility to restore this to downgrade.

谁能帮我恢复一下?

推荐答案

遗憾的是 SQL Server 不会倒退.您可以执行此操作的唯一方法是使用 SSIS 传输数据，或者您可以使用导入/导出实用程序.

Unfortunately SQL Server will not go backwards. The only way you can do this is Using SSIS to transfer the data or you can use the import/export utility.

在您的 2012 服务器上右键单击要从中导出数据的数据库并向下滚动到任务，然后选择导出数据，它将让您插入源服务器和目标服务器的所有信息，然后在摘要页面上单击映射并确保它们适合您的需要，并且它要访问的数据库是正确的.然后按照屏幕操作，直到您可以单击完成.您可能玩得太久了，无法让它表现得很好，但这应该对您有用.

On your 2012 Server Right click on the DB you want to export data from and scroll down to tasks and then choose export data it will have you then insert all of the information for both the source and destination servers then on the summary page click mappings and make sure they are correct for what you need and the DB it is going to is correct. Then follow the screens until you can click finish. YOu may have too play with it for a little bit to get it to behave nicely but this should work for you.

如果您只有一个 BAK 文件，您可能需要先将其重新加载到 2012 服务器上的虚拟数据库中.

If all you have is a BAK file you may have to resotre it to a dummy DB on the 2012 server first.

这篇关于如何使用 .bak 文件将数据从 MS SQL 2012 恢复到 MS SQL 2008.这可能吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！