无法从 100.0 服务器上的 100.50 备份恢复数据库
我有一个在 MS SQL Server 100.50 版本上制作的备份，我尝试在 MS SQL Server 上还原它100.0版本。我收到错误消息“数据库已在运行版本 10.50.1617 的服务器上备份。该版本与运行版本 10.00.5500 的服务器不兼容。请在支持备份的服务器上还原数据库，或使用与此服务器兼容的备份。”。那么我该如何恢复呢？我可以看到以下解决方案：
- 为我的数据库版本创建备份。为此，我尝试将 100.50 服务器上的原始数据库的兼容性级别设置为 90 (MS SQL Server 2005)，但它仍然生成相同的备份文件。还没有找到其他方法来做到这一点。
- 将我的 SQL Server 实例更新到 100.50 版本。还没找到怎么做。
也许还有其他我还不知道的方法可以解决这个问题。欢迎任何建议！
Possible Duplicate:
Is it possible to restore Sql Server 2008 backup in sql server 2005
I have a backup that was made on MS SQL Server 100.50 version, and I attempt to restore it on a MS SQL Server 100.0 version. I get an error message "The database was backed up on a server running version 10.50.1617. That version is incompatible with this server, which is running version 10.00.5500. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.". So how do I restore it? I can see following solutions:
- Create a backup for my version of database. To do this I've tried to set the compatibility level of the original database on 100.50 server to 90 (MS SQL Server 2005), but it still produces same backup file. Haven't found other ways to do it.
- Update my SQL Server instance to 100.50 version. Haven't found how to do it yet.
Maybe there are other ways to solve this problem about which I am not aware yet. Any advice is welcome!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
安装您从中进行备份的数据库版本的另一个实例。
然后您可以将备份恢复到该实例中。
之后，您可以使用迁移工具将数据库的内容移回旧服务器。
当我遇到同样的问题时，我就是这样做的。
也许其他人发布了更棘手的方法。
Install another instance of the database version you have the backup from.
Then you can restore you backup into this instance.
After that you can use the migrations tool to move the content of the database back to you old server.
That is how I did it when I had the same problem once.
Maybe someone else post a more tricky way.