是否可以在 sql server 2005 中恢复 Sql Server 2008 备份 [英] Is it possible to restore Sql Server 2008 backup in sql server 2005

问题描述

是否可以将 SQL Server 2008 数据库的备份还原到 SQL Server 2005 的实例上?

Is it possible to restore a backup of a SQL Server 2008 database onto an instance of SQL Server 2005?

我需要处理一个示例应用程序，该应用程序的数据库备份在 sql server 2008 中.但是我无法安装 2008.那么是否可以在 2005 中恢复备份?

I need to work on an sample application for which database backup is in sql server 2008. But I'll not be able to install 2008. So is it possible to restore that back up in 2005?

推荐答案

没有.无法从较新版本的备份中恢复数据库.

No. It is not possible to restore a database from a backup of a newer version.

如果你对它死心塌地，我认为你最好的选择是在 SQL 2008 的对象资源管理器中选择数据库，右键单击，选择任务-> 生成脚本.在选项对话框中启用所有内容，包括脚本数据.

If you are dead set on it, I think your best option is to selet the database in the Object Explorer in SQL 2008, right-click, select Tasks->Generate Scripts.In the options dialog emable about everything, including Script Data.

并确保您选择了SQL 2005 脚本".

And make sure you select "Script for SQL 2005".

来源

在将对象导入目标服务器时，如果对象很大，您可能会发现无法通过 Management Studio 打开 SQL 文件(完全没有用的操作无法完成"错误，不少).没关系，只需通过 sqlcmd 加载文件.

When importing the objects into your target server, if the objects are large you may find that you can't open the SQL file via Management Studio (with a completely useless "The operation could not be completed" error, no less). That's okay, just load the file via sqlcmd.

这篇关于是否可以在 sql server 2005 中恢复 Sql Server 2008 备份的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！