SQL Server 数据库内部版本号

Internal SQL Server Database Version Numbers

A database created by a more recent version of SQL Server cannot be attached or restored to an earlier version. This restriction is simply because an older version cannot know about file format changes that were introduced in the newer release. 

较新版本的SQL Server创建的数据库，不能附加或还原到较早的版本。这个限制仅仅是因为无法知道新版本中有关文件格式的变化。

If you attempt to attach a database to an earlier version, you will get SQL Server error 948 with the internal version numbers listed in the error message text. For example, the following error occurs if you try to attach a SQL Server 2008 R2 database to a SQL Server 2008 server:

如果您试图附加一个数据库到一个较早的版本，你会得到错误消息，的文本中列出的内部版本号码与SQL Server错误948。例如，出现以下错误如果您尝试连接到SQL Server 2008服务器的SQL Server 2008 R2数据库：

The database 'MyDatabase' cannot be opened because it is version 665. This server supports version 661 and earlier. A downgrade path is not supported.

“MyDatabase" 的数据库无法打开，因为它是665版本。该服务器支持661和更早版本。不支持降级路径。

Sample text from SQL Server error 948

从SQL Server错误948的样本文本

The cryptic version numbers in the error message refer to the internal database version. These internal version numbers are undocumented but are (at least currently) the same value reported by the DATABASEPROPERTYEX function 'Version' property of the source database. If you are unsure of the source database version, the table below maps the internal version numbers to SQL Server versions so you can determine the minimum version you need for the attach to succeed:

神秘的版本号错误消息是指内部的数据库版本。这些内部版本号是无证的，但（至少目前）DATABASEPROPERTYEX函数'版本'源数据库的属性值相同报道。如果你不确定是源数据库的版本，下面的映射表的SQL Server版本的内部版本号，以便您可以决定您需要的附加成功的最低版本：

SQL Server Version

Internal Database Version

SQL Server 2008 R2

665

SQL Server 2008

661

SQL Server 2005 SP2+ with vardecimal enabled

612

SQL Server 2005

611

SQL Server 2000

539

SQL Server 7

515

SQL Server versions and internal database versions

Below are the allowable SQL Server upgrade paths for a database attach or restore. The internal database version will be as above after a successful attach or restore.

下面是允许的SQL Server数据库附加或还原的升级路径。附加或还原成功后内部的数据库版本将更改为高的版本号。

Target SQL Server Version

Source SQL Server Version

Internal Database Version

SQL Server 2008 R2

SQL Server 2008 R2

665

SQL Server 2008

661

SQL Server 2005 with vardecimal enabled

612

SQL Server 2005

611

SQL Server 2000

539

SQL Server 2008

SQL Server 2008

661

SQL Server 2005 with vardecimal enabled

612

SQL Server 2005

611

SQL Server 2000

539

SQL Server 2005 SP2+

SQL Server 2005 with vardecimal enabled

612

SQL Server 2005

611

SQL Server 2000

539

SQL Server 7

515

SQL Server 2005

SQL Server 2005

611

SQL Server 2000

539

SQL Server 7

515

SQL Server 2000

SQL Server 2000

539

SQL Server 7

515

SQL Server 7

SQL Server 7

515

Database File Versions and Upgrade Paths

As I mentioned earlier, downgrades are not supported. You’ll need to copy objects and data from the newer source database to the older target if you need to downgrade; attach or restore is not an option to copy a database to an earlier version.

正如我刚才所说，不支持降级。你需要复制对象和数据从源数据库更新到旧的目标，如果你需要降级附加或还原数据库复制到一个较早的版本是不是一种选择。

[电脑翻译的，稍作整理 看懂就行，毕竟不是外语考试嘛  呵呵]