SQL Server 數據庫內部版本號

2019-11-10 20:13:26

字體：大中小

來源：轉載

供稿：網友

原文：http://blog.csdn.net/leamonjxl/article/details/8508974

-----------數據庫還原出現版本錯誤時可參考。

Internal SQL Server Database Version NumbersA 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 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.正如我剛才所說，不支持降級。你需要復制對象和數據從源數據庫更新到舊的目標，如果你需要降級附加或還原數據庫復制到一個較早的版本是不是一種選擇。

上一篇：HTTP請求頭信息

下一篇：Leetcode 198. House Robber