升級 SQL Server 容錯移轉叢集執行個體 (安裝程式)Upgrade a SQL Server Failover Cluster Instance (Setup)

您可以使用 [SQL Server]SQL Server 安裝精靈或命令提示字元,將 SQL Server 2014SQL Server 2014 容錯移轉叢集升級為 [SQL Server]SQL Server 容錯移轉叢集。You can upgrade a [SQL Server]SQL Server failover cluster to a SQL Server 2014SQL Server 2014 failover cluster by using the [SQL Server]SQL Server Installation Wizard or a command prompt.

在容錯移轉叢集升級期間,停機時間僅包含容錯移轉時間以及執行升級指令碼所需的時間。During the failover cluster upgrade, downtime is limited to failover time and the time that is required for upgrade scripts to run. 如果您遵循容錯移轉叢集輪流升級程序,就會將停機時間減到最少。If you follow the failover cluster rolling upgrade process, your downtime is minimal. 視您是否在容錯移轉叢集節點上設有所有必要元件而定,您可能會在安裝這些必要元件時造成額外的停機時間。Depending on whether you have all the prerequisites on the failover cluster nodes, you might incur additional downtime while you install these prerequisites. 如需如何在升級期間減少停機時間的詳細資訊,請參閱最佳做法升級容錯移轉叢集之前頁面一節。For more information about how to minimize the downtime during upgrade, see the Best Practices Before Upgrading Failover Cluster section on this page.

如需如何升級的詳細資訊,請參閱Supported Version and Edition Upgrades升級至 SQL Server 2014For more information about how to upgrade, see Supported Version and Edition Upgrades and Upgrade to SQL Server 2014.

如需有關命令提示字元使用方式的範例語法的詳細資訊,請參閱 < 從命令提示字元安裝 SQL Server 2014For more information about sample syntax for command prompt usage, see Install SQL Server 2014 from the Command Prompt.

先決條件Prerequisites

在開始之前,請檢閱以下重要資訊:Before you begin, review the following important information:

  • 安裝容錯移轉叢集之前Before Installing Failover Clustering

  • 使用 Upgrade Advisor 來準備升級Use Upgrade Advisor to Prepare for Upgrades.

  • 升級 Database EngineUpgrade Database Engine

  • 安裝程式會在叢集作業系統上安裝 .NET Framework 4.0。Setup installs .NET Framework 4.0 on a clustered operating system. 若要盡量縮短任何可能的停機時間,您可以考慮在執行安裝程式前先安裝 .NET Framework 4.0。To minimize any possible downtime, consider installing .NET Framework 4.0 before you run Setup.

  • 若要確定 Visual Studio 元件可以正確安裝, [SQL Server]SQL Server 需要安裝更新。To make sure that the Visual Studio component can be installed correctly, [SQL Server]SQL Server requires you to install an update. [SQL Server]SQL Server 安裝程式會檢查此更新的狀態,然後需要您下載並安裝更新才能繼續安裝 [SQL Server]SQL ServerSetup checks for the presence of this update and then requires you to download and install the update before you can continue with the [SQL Server]SQL Server installation. 若要避免 [SQL Server]SQL Server 安裝程式期間的中斷,您可以先下載並安裝更新,然後執行如下所述的 [SQL Server]SQL Server 安裝程式 (或安裝 Windows Update 上可用 .NET 3.5 SP1 的所有更新):To avoid the interruption during [SQL Server]SQL Server Setup, you can download and install the update before running [SQL Server]SQL Server Setup as described below (or install all the updates for .NET 3.5 SP1 available on Windows Update):

    如果您安裝SQL Server 2014SQL Server 2014上與 Windows Server 2008 SP2 作業系統的電腦,您可以取得必要的更新這裡If you install SQL Server 2014SQL Server 2014 on a computer with the Windows Server 2008 SP2 operating system, you can get the required update from here

    如果您將 SQL Server 2014SQL Server 2014 安裝在 Windows 7Windows 7 SP1 或 Windows Server 2008 R2Windows Server 2008 R2 SP1 作業系統的電腦上,則已包含此更新。If you install SQL Server 2014SQL Server 2014 on a computer with the Windows 7Windows 7 SP1 or Windows Server 2008 R2Windows Server 2008 R2 SP1 operating system, this update in included.

  • [SQL Server]SQL Server 安裝程式不再安裝 .NET Framework 3.5 SP1,但是在 [SQL Server]SQL Server 上安裝 Windows Server 2008Windows Server 2008 時,可能會需要 .NET Framework 3.5 SP1。.NET Framework 3.5 SP1 is no longer installed by [SQL Server]SQL Server Setup, but may be required while installing [SQL Server]SQL Server on Windows Server 2008Windows Server 2008. 如需詳細資訊,請參閱 SQL Server 2014SQL Server 2014版本資訊For more information, see SQL Server 2014SQL Server 2014Release Notes.

  • 若是本機安裝,您必須以管理員身分執行 [SQL Server]SQL Server 安裝程式。For local installations, you must run [SQL Server]SQL Server Setup as an administrator. 如果您是從遠端共用位置安裝 [SQL Server]SQL Server ,則必須使用對遠端共用位置具有讀取權限的網域帳戶。If you install [SQL Server]SQL Server from a remote share, you must use a domain account that has read permissions on the remote share.

  • 若要升級的執行個體[SQL Server]SQL ServerSQL Server 2014SQL Server 2014容錯移轉叢集,正在升級的執行個體必須是一個容錯移轉叢集。To upgrade an instance of [SQL Server]SQL Server to a SQL Server 2014SQL Server 2014 failover cluster, the instance being upgraded must be a failover cluster.

    若要將獨立的 [SQL Server]SQL Server 執行個體移動到 SQL Server 2014SQL Server 2014 容錯移轉叢集,請安裝新的 SQL Server 2014SQL Server 2014 容錯移轉叢集,然後利用「複製資料庫精靈」,從獨立的執行個體移轉使用者資料庫。To move a stand-alone instance of [SQL Server]SQL Server to a SQL Server 2014SQL Server 2014 failover cluster, install a new SQL Server 2014SQL Server 2014 failover cluster, and then migrate user databases from the stand-alone instance by using the Copy Database Wizard. 如需詳細資訊,請參閱 Use the Copy Database WizardFor more information, see Use the Copy Database Wizard.

輪流升級Rolling Upgrades

若要將 [SQL Server]SQL Server 容錯移轉叢集升級為 SQL Server 2014SQL Server 2014,您必須在每個容錯移轉叢集節點上使用升級動作來執行安裝程式 (從被動節點開始,一次一個)。To upgrade a [SQL Server]SQL Server failover cluster to SQL Server 2014SQL Server 2014, you must run setup with upgrade action on each failover cluster node, one at a time, starting with the passive nodes. 當您升級每個節點時,它就不會包含在容錯移轉叢集的可能擁有者中。As you upgrade each node, it is left out of the possible owners of the failover cluster. 如果發生非預期的容錯移轉,在 [SQL Server]SQL Server 安裝程式將叢集資源群組擁有權移至升級的節點之前,升級的節點不會參與容錯移轉。If there is an unexpected failover, the upgraded nodes do not participate in the failover until cluster resource group ownership is moved to an upgraded node by [SQL Server]SQL Server Setup.

根據預設,安裝程式會自動決定容錯移轉至升級節點的時機。By default, Setup automatically determines when to fail over to an upgraded node. 這個時機會取決於容錯移轉叢集執行個體中的節點總數以及已經升級的節點數目而定。This depends on the total number of nodes in the failover cluster instance and the number of nodes that have already been upgraded. 如果半數以上的節點都已經升級,當您在下一個節點上執行升級時,安裝程式就會導致系統容錯移轉至升級的節點。When half of the nodes or more have already been upgraded, Setup causes a failover to an upgraded node when you perform upgrade on the next node. 容錯移轉至升級的節點之後,叢集群組就會移至升級的節點。Upon failover to an upgraded node, the cluster group is moved to an upgraded node. 系統會將所有升級的節點都放置在可能擁有者的清單中,並從可能擁有者的清單中移除尚未升級的所有節點。All the upgraded nodes are put in the possible owners list and all the nodes that are not yet upgraded are removed from the possible owners list. 當您升級其餘每個節點時,它就會加入至容錯移轉叢集的可能擁有者。As you upgrade each remaining node, it is added to the possible owners of the failover cluster.

這個程序會導致停機時間僅會包含整個容錯移轉叢集升級期間的單一容錯移轉時間和資料庫升級指令碼執行時間。This process results in downtime limited to one failover time and database upgrade script execution time during the whole failover cluster upgrade.

若要在升級程序期間控制叢集節點的容錯移轉行為,請從命令提示字元執行升級作業,然後使用 /FAILOVERCLUSTERROLLOWNERSHIP 參數。To control the failover behavior of cluster nodes during the upgrade process, run the upgrade operation at the command prompt and use the /FAILOVERCLUSTERROLLOWNERSHIP parameter. 如需詳細資訊,請參閱從命令提示字元安裝 SQL Server 2014For more information, see Install SQL Server 2014 from the Command Prompt.

附註單一節點容錯移轉叢集,是否[SQL Server]SQL Server安裝程式會讓[SQL Server]SQL Server資源群組離線。Note If there is a single-node failover cluster, [SQL Server]SQL Server Setup takes the [SQL Server]SQL Server resource group offline.

SQL Server 2005SQL Server 2005 升級時的考量Considerations when Upgrading from SQL Server 2005SQL Server 2005

如果您為叢集安全性原則指定了網域群組,就無法在 Windows Server 2008Windows Server 2008 上指定服務 SID。If you specified domain groups for the cluster security policy, you cannot specify service SID on Windows Server 2008Windows Server 2008. 如果您想要使用服務 SID,則需要執行並存升級。If you want to use the service SID, you need to perform a side by side upgrade.

當您選取 Database EngineDatabase Engine 進行升級時,全文檢索搜尋會包含在安裝程式中,不論它是否已在 SQL Server 2005SQL Server 2005 中安裝。When you select Database EngineDatabase Engine for upgrade, full-text search is included in the setup regardless of whether it was installed in SQL Server 2005SQL Server 2005.

如果已在 SQL Server 2005SQL Server 2005 中啟用全文檢索搜尋,安裝程式會重建全文檢索搜尋目錄,不論可供您使用的選項為何。If full-text search was enabled in SQL Server 2005SQL Server 2005, Setup rebuilds the full-text search catalog regardless of the options available to you.

升級至 SQL Server 2014SQL Server 2014 多重子網路容錯移轉叢集Upgrading to a SQL Server 2014SQL Server 2014 Multi-Subnet Failover Cluster

可能的升級案例有兩種:There are two possible scenarios for upgrades:

  1. [SQL Server]SQL Server 容錯移轉叢集目前設定在單一子網路:您必須先升級現有的叢集,以SQL Server 2014SQL Server 2014啟動安裝程式並遵循升級程序。failover cluster is currently configured on a single subnet: You must first upgrade the existing cluster to SQL Server 2014SQL Server 2014 by launching Setup and following the upgrade process. 在完成升級現有的容錯移轉叢集之後,使用 AddNode 功能,以加入位在不同子網路上的節點。After completing the upgrade of the existing failover cluster, add a node that is on a different subnet using the AddNode functionality. 請確認叢集網路組態頁面中的 IP 位址資源相依性已變更為 OR。Confirm the IP address resource dependency change to OR in the cluster network configuration page. 您現在已擁有 [SQL Server]SQL Server 多重子網路容錯移轉叢集。You now have a [SQL Server]SQL Server multi-subnet failover cluster.

  2. [SQL Server]SQL Server 容錯移轉叢集目前設定在使用延展 V-LAN 技術的多個子網路:您必須先升級現有的叢集,以SQL Server 2014SQL Server 2014failover cluster is currently configured on multiple subnets using the stretch V-LAN technology: You must first upgrade the existing cluster to SQL Server 2014SQL Server 2014. 由於延伸 V-LAN 技術會設定單一子網路網路,網路組態必須變更為多重子網路,而且要使用 Windows 容錯移轉叢集管理工具變更 IP 位址資源相依性,並將 IP 相依性變更為 OR。Because stretch V-LAN technology configures a single subnet, the network configuration must to be changed to multiple subnets, and change the IP address resource dependency using the Windows Failover Cluster administration tool and change the IP dependency to OR.

在升級之前的最佳作法[SQL Server]SQL Server容錯移轉叢集Best Practices Before Upgrading a [SQL Server]SQL Server Failover Cluster

若要排除重新啟動所產生的非預期停機時間,請在所有容錯移轉叢集節點上預先安裝 .NET Framework 4.0 的不必重新開機封裝,然後在叢集節點上執行升級。To eliminate unexpected downtime caused by a restart, preinstall the no-reboot package for .NET Framework 4.0 on all the failover cluster nodes before you run the upgrade on the cluster nodes. 下面是預先安裝必要元件的建議步驟:We recommend the following steps to preinstall the prerequisites:

  • 安裝 .NET 4.0 的不必重新開機封裝,並且只升級以被動節點開始的共用元件。Install the no-reboot package for .NET Framework 4.0, and upgrade only the shared components starting with the passive nodes. 這樣會安裝 .NET Framework.NET Framework 4.0、Windows Installer 4.5 和 [SQL Server]SQL Server 的支援檔案。This installs .NET Framework.NET Framework 4.0, Windows Installer 4.5, and [SQL Server]SQL Server support files.

  • 視需要重新啟動一次或多次。Restart one or more times, as required.

  • 容錯移轉至升級的節點。Fail over to an upgraded node.

  • 在剩餘的最後一個節點上升級共用的元件。Upgrade the shared components on the last remaining node.

當您已經升級所有共用的元件而且已經安裝必要元件之後,請啟動容錯移轉叢集升級程序。After all the shared components are upgraded and prerequisites are installed, start the failover cluster upgrade process. 您必須在每個容錯移轉叢集節點上執行升級,從被動節點開始而且直到擁有叢集資源群組的節點為止。You have to run upgrade on each failover cluster node, starting with the passive nodes first and making your way toward the node that owns the cluster resource group.

  • 您無法將功能加入至現有的容錯移轉叢集。You cannot add features to an existing failover cluster.

  • 變更容錯移轉叢集的版本會受限於特定狀況。Changing the edition of the failover cluster is limited to certain scenarios. 如需詳細資訊,請參閱 支援的版本與版本升級For more information, see Supported Version and Edition Upgrades.

若要升級 [SQL Server]SQL Server 容錯移轉叢集To Upgrade a [SQL Server]SQL Server Failover Cluster

若要升級 [SQL Server]SQL Server 容錯移轉叢集To upgrade a [SQL Server]SQL Server failover cluster

  1. 插入 [SQL Server]SQL Server 安裝媒體,然後在根資料夾中,按兩下 Setup.exe。Insert the [SQL Server]SQL Server installation media, and from the root folder, double-click Setup.exe. 若要從網路共用區進行安裝,請移到共用區上的根資料夾,然後按兩下 Setup.exe。To install from a network share, move to the root folder on the share, and then double-click Setup.exe. 如果您之前未安裝必要元件,系統可能會要求您安裝。You may be asked to install the prerequisites, if they are not previously installed.

  2. 重要

    如需有關步驟 3 和 4 的詳細資訊,請參閱 < 最佳做法升級容錯移轉叢集之前一節。For more information about steps 3 and 4, see the Best Practices Before Upgrading Failover Cluster section.

  3. 安裝必要元件之後,安裝精靈會啟動 [SQL Server]SQL Server 安裝中心。After prerequisites are installed, the Installation Wizard starts the [SQL Server]SQL Server Installation Center. 若要升級現有的執行個體[SQL Server]SQL Server,按一下從升級SQL Server 2005SQL Server 2005SQL Server 2008SQL Server 2008SQL Server 2008 R2SQL Server 2008 R2,或SQL Server 2012SQL Server 2012To upgrade an existing instance of [SQL Server]SQL Server, click Upgrade from SQL Server 2005SQL Server 2005, SQL Server 2008SQL Server 2008, SQL Server 2008 R2SQL Server 2008 R2, or SQL Server 2012SQL Server 2012.

  4. 如果需要安裝程式支援檔案, [SQL Server]SQL Server 安裝程式就會安裝這些檔案。If Setup support files are required, [SQL Server]SQL Server Setup installs them. 如果系統指示您重新啟動電腦,請先重新啟動,然後再繼續進行。If you are instructed to restart your computer, restart before you continue.

  5. 系統組態檢查會在電腦上執行探索作業。The System Configuration Checker runs a discovery operation on your computer. 若要繼續,請按一下 [確定] 。Click OK.To continue, 按一下 [確定] 。Click OK..

  6. 在 [產品金鑰] 頁面上,針對符合舊產品版本的新版本輸入 PID 金鑰。On the Product Key page, enter the PID key for the new version edition that matches the edition of the old product version. 例如,若要升級 Enterprise 容錯移轉叢集,您必須提供 SQL Server EnterpriseSQL Server Enterprise的 PID 金鑰。For example, to upgrade an Enterprise failover cluster, you must supply a PID key for SQL Server EnterpriseSQL Server Enterprise. [下一步] ,繼續進行。Click Next to continue. 請注意,您針對容錯移轉叢集升級所使用的 PID 金鑰在相同 [SQL Server]SQL Server 執行個體的所有容錯移轉叢集節點之間必須一致。Be aware that the PID key that you use for a failover cluster upgrade must be consistent across all failover cluster nodes in the same [SQL Server]SQL Server instance. 如需詳細資訊,請參閱 < 版本和 SQL Server 2014 元件Supported Version and Edition UpgradesFor more information, see Editions and Components of SQL Server 2014 and Supported Version and Edition Upgrades.

  7. 在 [授權條款] 頁面上,閱讀授權合約,然後選取要接受授權條款和條件的核取方塊。On the License Terms page, read the license agreement, and then select the check box to accept the license terms and conditions. 若要協助提升 [SQL Server]SQL Server,您也可以啟用功能使用方式選項,並傳送報告給 MicrosoftMicrosoftTo help improve [SQL Server]SQL Server, you can also enable the feature usage option and send reports to MicrosoftMicrosoft. 按一下 [下一步] ,繼續進行。Click Next to continue. 若要結束安裝程式,請按一下 [取消]To end Setup, click Cancel.

  8. 在 [選取執行個體] 頁面中,指定要升級為 [SQL Server]SQL ServerSQL Server 2014SQL Server 2014 執行個體。On the Select Instance page, specify the [SQL Server]SQL Server instance to upgrade to SQL Server 2014SQL Server 2014. 按一下 [下一步] ,繼續進行。Click Next to continue.

  9. 在 [特徵選取] 頁面上,系統會預先選取要升級的功能。On the Feature Selection page, the features to upgrade are preselected. 當您選取功能名稱之後,每一個元件群組的描述就會出現在右窗格中。A description for each component group appears in the right pane after you select the feature name. 請注意,您無法變更要升級的功能,而且您無法在升級作業期間加入功能。Be aware that you cannot change the features to be upgraded, and you cannot add features during the upgrade operation. 若要將功能加入至升級的執行個體SQL Server 2014SQL Server 2014升級作業完成之後,請參閱將功能加入至執行個體 SQL Server 2014 的(安裝)To add features to an upgraded instance of SQL Server 2014SQL Server 2014 after the upgrade operation is complete, see Add Features to an Instance of SQL Server 2014 (Setup).

    右窗格會顯示選取功能的必要條件。The prerequisites for the selected features are displayed on the right-hand pane. SQL Server 安裝程式將會在這個程序稍後說明的安裝步驟期間安裝尚未安裝的必要條件。SQL Server Setup will install the prerequisite that are not already installed during the installation step described later in this procedure.

  10. 在 [執行個體組態] 頁面上,系統會根據舊的執行個體自動填入欄位。On the Instance Configuration page, fields are automatically populated from the old instance. 您可以選擇指定新的 InstanceID 值。You can choose to specify the new InstanceID value.

    執行個體識別碼 - 根據預設,此執行個體名稱會當做執行個體識別碼使用。Instance ID - By default, the instance name is used as the Instance ID. 這是用來識別 [SQL Server]SQL Server執行個體的安裝目錄和登錄機碼。This is used to identify installation directories and registry keys for your instance of [SQL Server]SQL Server. 這是預設執行個體和具名執行個體的狀況。This is the case for default instances and named instances. 如果是預設執行個體,執行個體名稱和執行個體識別碼將會是 MSSQLSERVER。For a default instance, the instance name and instance ID would be MSSQLSERVER. 若要使用非預設的執行個體識別碼,請選取 [執行個體識別碼] 核取方塊並提供值。To use a nondefault instance ID, select the Instance ID check box and provide a value. 如果您覆寫預設值,就必須針對在所有容錯移轉叢集節點上升級的執行個體指定相同的執行個體識別碼。If you override the default value, you must specify the same Instance ID for the instance being upgraded on all the failover cluster nodes. 升級之執行個體的執行個體識別碼在這些節點之間必須相符。The Instance ID for the upgraded instance must match across the nodes.

    偵測到執行個體和功能-此方格會顯示執行個體[SQL Server]SQL Server安裝程式執行所在的電腦上。Detected instances and features - The grid shows instances of [SQL Server]SQL Server that are on the computer where Setup is running. 按一下 [下一步] ,繼續進行。Click Next to continue.

  11. [磁碟空間需求] 頁面會計算您所指定之功能的所需磁碟空間,並且比較空間需求與執行安裝程式之電腦的可用磁碟空間。The Disk Space Requirements page calculates the required disk space for the features that you specify, and compares requirements to the available disk space on the computer where Setup is running.

  12. 在 [全文檢索搜尋升級] 頁面上,針對升級的資料庫指定升級選項。On the Full-Text Search Upgrade page, specify the upgrade options for the databases being upgraded. 如需詳細資訊,請參閱 全文檢索搜尋升級選項For more information, see Full-Text Search Upgrade Options.

  13. [錯誤報告] 頁面上,指定您想要傳送給 MicrosoftMicrosoft 的資訊,這可協助改善 [SQL Server]SQL ServerOn the Error Reporting page, specify the information that you want to send to MicrosoftMicrosoft that will help improve [SQL Server]SQL Server. 錯誤報告選項預設為啟用。By default, options for error reporting is enabled.

  14. 在升級作業開始之前,系統組態檢查會執行一組額外的規則,以便使用您已指定的 [SQL Server]SQL Server 功能來驗證電腦組態。The System Configuration Checker runs one more set of rules to validate your computer configuration with the [SQL Server]SQL Server features that you have specified, before the upgrade operation begins.

  15. [叢集升級報表] 頁面會顯示容錯移轉叢集執行個體中的節點清單以及每個節點上 [SQL Server]SQL Server 元件的執行個體版本資訊。The Cluster Upgrade Report page displays the list of nodes in the failover cluster instance and the instance version information for [SQL Server]SQL Server components on each node. 它會顯示資料庫指令碼狀態和複寫指令碼狀態。It displays the database script status and replication script status. 此外,它也會顯示當您按一下 [下一步] 時所進行之動作的參考用訊息。In addition, it also displays informational messages on what will occur when you click Next. 安裝程式將會根據已經升級和總計的節點數目的容錯移轉叢集節點數目,顯示當您按一下時所發生的容錯移轉行為下一步Depending on the number of failover cluster nodes that have already been upgraded and total number of nodes, Setup displays the failover behavior that happens when you click Next. 如果您尚未安裝必要元件,它也會發出可能產生不必要停機時間的警告。It also warns about potential unnecessary downtime if you have not installed the prerequisites already.

  16. [準備升級] 頁面會顯示在安裝期間指定之安裝選項的樹狀檢視。The Ready to Upgrade page displays a tree view of installation options that were specified during Setup. 若要繼續,請按一下 [升級]To continue, click Upgrade. [SQL Server]SQL Server 安裝程式會先安裝選取功能所需的必要條件,之後再進行功能安裝。Setup will first install the required prerequisites for the selected features followed by the feature installation.

  17. 在升級期間,[進度] 頁面會提供狀態,好讓您可以在安裝程式進行時監視目前節點的升級進度。During upgrade, the Progress page provides status so that you can monitor the upgrade progress on the current node as Setup continues.

  18. 升級目前的節點之後,[叢集升級報表] 頁面就會顯示所有容錯移轉叢集節點的升級狀態資訊、每個容錯移轉叢集節點的功能,以及其版本資訊。After the upgrade of the current node, the Cluster Upgrade Report page displays an upgrade status information for all the failover cluster nodes, features on each failover cluster node, and their version information. 請確認所顯示的版本資訊並且繼續進行其餘節點的升級作業。Confirm the version information that is displayed and continue with the upgrade of the remaining nodes. 如果發生容錯移轉至升級節點的行為,這也會出現在狀態頁面上。If the failover to upgraded nodes occurred, this is also apparent on the status page. 您也可以在 Windows 叢集管理員工具中檢查,然後確認。You can also check in the Windows Cluster administrator tool to confirm.

  19. 升級之後,[完成] 頁面會提供安裝和其他重要注意事項之摘要記錄檔的連結。After upgrade, the Complete page provides a link to the summary log file for the installation and other important notes. 若要完成 [SQL Server]SQL Server 安裝程序,請按一下 [關閉]To complete the [SQL Server]SQL Server installation process, click Close.

  20. 如果指示您重新啟動電腦,請立刻執行。If you are instructed to restart the computer, do so now. 當您完成安裝時,請務必閱讀安裝精靈所提供的訊息。It is important to read the message from the Installation Wizard when you have finished with Setup. 如需安裝程式記錄檔的詳細資訊,請參閱 檢視與讀取 SQL Server 安裝程式記錄檔For more information about Setup log files, see View and Read SQL Server Setup Log Files.

  21. 若要完成升級程序,請在 [SQL Server]SQL Server 容錯移轉叢集的所有其他節點上重複步驟 1 到 21。To complete the upgrade process, repeat steps 1 to 21 on all the other nodes on the [SQL Server]SQL Server failover cluster.

若要升級 [SQL Server]SQL Server 多重子網路容錯移轉叢集To upgrade a [SQL Server]SQL Server Multi-Subnet Failover Cluster

若要升級到 [SQL Server]SQL Server 多重子網路容錯移轉叢集 (現有的 [SQL Server]SQL Server 叢集為非多重子網路叢集)。To upgrade to a [SQL Server]SQL Server multi-subnet failover Cluster (Existing [SQL Server]SQL Server cluster is a non multi-subnet cluster).

  1. 請遵循步驟 1 到 24 中所述若要升級 SQL Server 容錯移轉叢集一節所述來將叢集升級SQL Server 2014SQL Server 2014Follow the steps 1 through 24 described in the To upgrade a SQL Server failover cluster section above to upgrade your cluster to SQL Server 2014SQL Server 2014.

  2. 使用 AddNode 安裝程式動作將節點加入到不同的子網路,並在 [叢集網路組態] 頁面確認 IP 位址資源相依性為 OR。Add a node on a different subnet using the AddNode Setup action and confirm the IP address resource dependency to OR on the Cluster Network Configuration page. 如需詳細資訊,請參閱在 SQL Server 容錯移轉叢集中新增或移除節點 (安裝程式)For more information, see Add or Remove Nodes in a SQL Server Failover Cluster (Setup).

若要升級目前使用延展 V-Lan 的多重子網路叢集。To upgrade a multi-subnet cluster currently using Stretch V-Lan.

  1. 請遵循步驟 1 到 24 中所述若要升級 SQL Server 容錯移轉叢集一節所述來將叢集升級SQL Server 2014SQL Server 2014Follow the steps 1 through 24 described in the To upgrade a SQL Server failover cluster section above to upgrade your cluster to SQL Server 2014SQL Server 2014.

  2. 變更網路設定,將遠端節點移到不同的子網路。Change the network settings to move the remote node to a different subnet.

  3. 使用 Windows 容錯移轉叢集管理工具,為新的子網路加入新的 IP 位址,並將 IP 位址資源相依性設定為 OR。Using the Windows Failover Cluster management tool, add a new IP address for the new subnet set the IP address resource dependency to OR.

後續步驟Next Steps

在升級為 SQL Server 2014SQL Server 2014之後,請完成下列工作:After you upgrade to SQL Server 2014SQL Server 2014, complete the following tasks:

  • 註冊伺服器Register your servers

    升級會移除先前 [SQL Server]SQL Server 執行個體的登錄設定。Upgrade removes registry settings for the previous [SQL Server]SQL Server instance. 在升級之後,您必須重新註冊伺服器。After you upgrade, you must reregister your servers.

  • 更新統計資料Update statistics

    若要協助最佳化查詢效能,我們建議您在升級之後,更新所有資料庫的統計資料。To help optimize query performance, we recommend that you update statistics on all databases following upgrade. 請使用 sp_updatestats 預存程序來更新 [SQL Server]SQL Server 資料庫中使用者定義資料表的統計資料。Use the sp_updatestats stored procedure to update statistics in user-defined tables in [SQL Server]SQL Server databases.

  • 設定新的 [SQL Server]SQL Server 安裝。Configure your new [SQL Server]SQL Server installation

    為了減少系統的可攻擊介面區, [SQL Server]SQL Server 可以選擇性地安裝和啟用主要服務和功能。To reduce the attackable surface area of a system, [SQL Server]SQL Server selectively installs and enables key services and features. 如需有關介面區組態的詳細資訊,請參閱這一版的讀我檔案。For more information about surface area configuration, see the readme file for this release.

另請參閱See Also

從命令提示字元安裝 SQL Server 2014 Install SQL Server 2014 from the Command Prompt
檢視與讀取 SQL Server 安裝程式記錄檔View and Read SQL Server Setup Log Files