SQL Server 数据库内部版本号

素颜马尾好姑娘i 2022-04-08 17:55 256阅读 0赞

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

[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数据库：

**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 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数据库附加或还原的升级路径。附加或还原成功后内部的数据库版本将更改为高的版本号 。

<table style="border-collapse:collapse; border-top-color:currentcolor; border-right-color:currentcolor; border-bottom-color:currentcolor; border-left-color:currentcolor; border-width:initial; border-style:initial"> 
 <tbody> 
  <tr> 
   <td style="padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; border-top-width:1pt; border-right-width:1pt; border-bottom-width:1pt; border-left-width:1pt; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-top-color:red; border-right-color:red; border-bottom-color:red; border-left-color:red; width:134.6pt; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial"> 
     <strong>Target SQL Server Version</strong> 
    </div> </td> 
   <td style="border-top-width:1pt; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:red; border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:202.5pt; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial"> 
     <strong>Source SQL Server Version</strong> 
    </div> </td> 
   <td style="border-top-width:1pt; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:red; border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:1.25in; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial"> 
     <strong>Internal Database Version</strong> 
    </div> </td> 
  </tr> 
  <tr> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:1pt; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:red; padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:134.6pt; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial">
      SQL Server 2008 R2 
    </div> </td> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:202.5pt; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial">
      SQL Server 2008 R2 
    </div> </td> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:1.25in; background-color:transparent"> <strong><br> </strong> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial"> 
     <strong>665</strong> 
    </div> </td> 
  </tr> 
  <tr> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:202.5pt; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial">
      SQL Server 2008 
    </div> </td> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:1.25in; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial">
      661 
    </div> </td> 
  </tr> 
  <tr> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:202.5pt; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial">
      SQL Server 2005 with vardecimal enabled 
    </div> </td> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:1.25in; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial">
      612 
    </div> </td> 
  </tr> 
  <tr> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:202.5pt; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial">
      SQL Server 2005 
    </div> </td> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:1.25in; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial">
      611 
    </div> </td> 
  </tr> 
  <tr> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:202.5pt; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial">
      SQL Server 2000 
    </div> </td> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:1.25in; background-color:transparent"> <strong><br> </strong> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial"> 
     <strong>539</strong> 
    </div> </td> 
  </tr> 
  <tr> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:1pt; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:red; padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:134.6pt; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial">
      SQL Server 2008 
    </div> </td> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:202.5pt; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial">
      SQL Server 2008 
    </div> </td> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:1.25in; background-color:transparent"> <strong><br> </strong> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial"> 
     <strong>661</strong> 
    </div> </td> 
  </tr> 
  <tr> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:202.5pt; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial">
      SQL Server 2005 with vardecimal enabled 
    </div> </td> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:1.25in; background-color:transparent"> <strong><br> </strong> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial"> 
     <strong>612</strong> 
    </div> </td> 
  </tr> 
  <tr> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:202.5pt; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial">
      SQL Server 2005 
    </div> </td> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:1.25in; background-color:transparent"> <strong><br> </strong> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial"> 
     <strong>611</strong> 
    </div> </td> 
  </tr> 
  <tr> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:202.5pt; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial">
      SQL Server 2000 
    </div> </td> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:1.25in; background-color:transparent"> <strong><br> </strong> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial"> 
     <strong>539</strong> 
    </div> </td> 
  </tr> 
  <tr> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:1pt; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:red; padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:134.6pt; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial">
      SQL Server 2005 SP2+ 
    </div> </td> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:202.5pt; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial">
      SQL Server 2005 with vardecimal enabled 
    </div> </td> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:1.25in; background-color:transparent"> <strong><br> </strong> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial"> 
     <strong>612</strong> 
    </div> </td> 
  </tr> 
  <tr> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:202.5pt; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial">
      SQL Server 2005 
    </div> </td> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:1.25in; background-color:transparent"> <strong><br> </strong> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial"> 
     <strong>611</strong> 
    </div> </td> 
  </tr> 
  <tr> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:202.5pt; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial">
      SQL Server 2000 
    </div> </td> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:1.25in; background-color:transparent"> <strong><br> </strong> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial"> 
     <strong>539</strong> 
    </div> </td> 
  </tr> 
  <tr> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:202.5pt; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial">
      SQL Server 7 
    </div> </td> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:1.25in; background-color:transparent"> <strong><br> </strong> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial"> 
     <strong>515</strong> 
    </div> </td> 
  </tr> 
  <tr> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:1pt; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:red; padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:134.6pt; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial">
      SQL Server 2005 
    </div> </td> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:202.5pt; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial">
      SQL Server 2005 
    </div> </td> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:1.25in; background-color:transparent"> <strong><br> </strong> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial"> 
     <strong>611</strong> 
    </div> </td> 
  </tr> 
  <tr> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:202.5pt; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial">
      SQL Server 2000 
    </div> </td> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:1.25in; background-color:transparent"> <strong><br> </strong> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial"> 
     <strong>539</strong> 
    </div> </td> 
  </tr> 
  <tr> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:202.5pt; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial">
      SQL Server 7 
    </div> </td> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:1.25in; background-color:transparent"> <strong><br> </strong> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial"> 
     <strong>515</strong> 
    </div> </td> 
  </tr> 
  <tr> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:1pt; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:red; padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:134.6pt; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial">
      SQL Server 2000 
    </div> </td> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:202.5pt; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial">
      SQL Server 2000 
    </div> </td> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:1.25in; background-color:transparent"> <strong><br> </strong> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial"> 
     <strong>539</strong> 
    </div> </td> 
  </tr> 
  <tr> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:202.5pt; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial">
      SQL Server 7 
    </div> </td> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:1.25in; background-color:transparent"> <strong><br> </strong> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial"> 
     <strong>515</strong> 
    </div> </td> 
  </tr> 
  <tr> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:1pt; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:red; padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:134.6pt; background-color:transparent"> <br> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial">
      SQL Server 7 
    </div> </td> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:202.5pt; background-color:transparent"> <br> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial">
      SQL Server 7 
    </div> </td> 
   <td style="border-top-width:medium; border-right-width:1pt; border-bottom-width:1pt; border-left-width:medium; border-top-style:none; border-right-style:solid; border-bottom-style:solid; border-left-style:none; border-top-color:rgb(240,240,240); border-right-color:red; border-bottom-color:red; border-left-color:rgb(240,240,240); padding-top:0in; padding-right:5.4pt; padding-bottom:0in; padding-left:5.4pt; width:1.25in; background-color:transparent"> <strong><br> </strong> 
    <div style="margin-top:0in; margin-right:0in; margin-bottom:10pt; margin-left:0in; padding-top:0px; padding-right:0px; padding-bottom:0px; padding-left:0px; border-top-width:0px; border-right-width:0px; border-bottom-width:0px; border-left-width:0px; border-style:initial; border-color:initial; page-break-after:avoid"> 
     <strong>515</strong> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

**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.

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

[Internal SQL Server Database Version Numbers]: http://weblogs.sqlteam.com/dang/archive/2011/07/17/internal-sql-server-database-version-numbers.aspx