【转】SQL Server 数据库内部版本号

2024-08-31 00:55:11

字体：大中小

来源：转载

供稿：网友

-----------数据库还原或版本升级出现版本错误时可参考。

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和更早版本。不支持降级路径。

可以利用SQL语句查看本机数据库版本：

select @@VERSION

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 versionsBelow 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 2000	SQL Server 7	515
SQL Server 7	SQL Server 7	515

Database File Versions and Upgrade PathsAs 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.正如我刚才所说，不支持降级。你需要复制对象和数据从源数据库更新到旧的目标，如果你需要降级附加或还原数据库复制到一个较早的版本是不是一种选择。

上一篇：SQL SERVER2008及以上版本数据库自动备份的三种方法

下一篇：SQL Server 触发器创建、删除、修改、查看示例