如何在 SQL Server 2008 中恢复 SQL Server 2014 备份 [英] How to restore SQL Server 2014 backup in SQL Server 2008
问题描述
SQL Server 2014 在这方面有什么变化吗?我看过这篇文章 是否可以在 sql server 2005 中恢复 Sql Server 2008 备份，我知道这不可能作为 2012 -> 2008 的场景，但我想知道 MS 是否对 2014 版本进行了任何更改.
Were there any changes in this area with SQL Server 2014? I’ve seen this post Is it possible to restore Sql Server 2008 backup in sql server 2005 and I know that this was not possible as a scenario for 2012 -> 2008 but I wonder if MS made any changes here with the 2014 version.
我们正在评估 2014 版本，我们有一个相当大的数据库正在测试中.我们想将该数据库的备份恢复到 SQL Server 2008，因为该物理机有更多空间、RAM、......
We are evaluating 2014 version and we have a fairly large database in testing. We’d like to restore a backup of that database to SQL Server 2008 because that physical machine has more space, RAM,…
当我尝试恢复备份时收到标准错误消息，但我想知道 SQL Server 2014 中是否还有我可能遗漏的其他内容.
I’m getting standard error message when I try to restore backup but I was wondering if there is something else in SQL Server 2014 that I might be missing.
推荐答案
据我所知不是很清楚，但您可以尝试以下几件事.
Not really as far as I know but here are couple things you can try.
第三方工具:在 2008 实例上创建空数据库并使用第三方工具，例如 ApexSQL Diff 和 Data Diff 以同步架构和表.
Third party tools: Create empty database on 2008 instance and use third party tools such as ApexSQL Diff and Data Diff to synchronize schema and tables.
只需在试用模式下使用这些(或市场上的任何其他产品，例如 Red Gate、Idera、Dev Art，有很多类似的)即可完成工作.
Just use these (or any other on the market such as Red Gate, Idera, Dev Art, there are many similar) in trial mode to get the job done.
生成脚本:转到任务 -> 生成脚本，选择选项来编写数据脚本并在 2008 实例上执行.工作正常，但请注意脚本顺序是您必须小心的事情.默认情况下，脚本不会被排序以考虑依赖项.
Generate scripts: Go to Tasks -> Generate Scripts, select option to script the data too and execute it on 2008 instance. Works just fine but note that script order is something you must be careful about. By default scripts are not ordered to take dependencies into account.
这篇关于如何在 SQL Server 2008 中恢复 SQL Server 2014 备份的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
