【转】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和更早版本。不支持降级路径。
|
可以利用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 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.
正如我刚才所说，不支持降级。你需要复制对象和数据从源数据库更新到旧的目标，如果你需要降级附加或还原数据库复制到一个较早的版本是不是一种选择。
