-----------數據庫還原或版本升級出現版本錯誤時可參考。
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 |
| 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 |
新聞熱點
疑難解答
