在 SharePoint 2013 中新增資料庫伺服器至現有的伺服器陣列Add a database server to an existing farm in SharePoint 2013

摘要: 了解如何新增資料庫伺服器到現有的 SharePoint 伺服器陣列。Summary: Learn how to add a new database server to an existing SharePoint farm.

您隨時可以新增更多資料庫伺服器,以因應商務或作業需求。因為資料庫伺服器包含伺服器陣列內容,而伺服器陣列內容可能包括各種不同的資料以及快速累積的文件,所以伺服器陣列資料庫的體積可能會快速成長。儲存容量不足通常是新增更多資料庫伺服器的主因。其他原因包括新增功能、改善效能和獲得高可用性。You can add more database servers at any time to respond to business or operations requirements. Because a database server contains the farm content, which can consist of diverse types of data and can have a fast growing document collection, the size of the farm databases can grow quickly. Storage capacity is often the key reason to add more database servers. Other reasons can include adding new features, improving performance and high availability.

開始之前Before you begin

一般而言,若要新增資料庫伺服器到現有的 SharePoint 伺服器陣列,只需要安裝並設定新的資料庫伺服器,然後在您新增功能至或移動資料庫內容至新的伺服器時,提到新的伺服器,即可將其加入伺服器陣列。SharePoint 2013 會自動適時配置並指派新的資料庫資源。Normally, all that is required to add a database server to an existing SharePoint farm is to set up and configure a new database server and join it to the farm by referencing the new server when you add a feature or move database content to the new server. SharePoint 2013 automatically allocates and assigns new database resources as necessary when they are required.

注意

在為了要獲得高可用性的案例中,這通常是在一開始的伺服器陣列拓撲設計和部署中就實作,此不在本文的討論範圍內。如需 SQL Server 2008 R2 與 SQL Server 2012 高可用性的詳細資訊,請參閱<高可用性解決方案概觀>和<高可用性解決方案 (SQL Server)>。In the case of high availability, this is typically implemented as part of the initial farm topology design and deployment and is not included in this article. For more information about high availability for SQL Server 2008 R2 and SQL Server 2012, see High Availability Solution Overview and High Availability Solutions (SQL Server).

本文中的程序主要在示範如何在 SharePoint 2013 中針對特定工作設定新的資料庫伺服器。The procedures in this article are intended to show how to configure a new database server for a specific task in SharePoint 2013.

準備新的資料庫伺服器Prepare the new database server

在 SharePoint 2013 伺服器陣列中使用新的資料庫伺服器之前,必須先對新的資料庫伺服器執行一些準備工作。請使用下列步驟作為佈建新伺服器的指引。Before you can use the new database server, you must prepare it so that it can be used in a SharePoint 2013 farm. Use the following steps as guidance to provision the new server.

重要

IT 原則可能會需要資料庫管理員 (DBA) 完成這些程序中的部份或所有步驟。IT policy may require a database administrator (DBA) to complete some or all steps in these procedures.

佈建資料庫伺服器To provision the database server

  1. 確認執行此程序的使用者帳戶是 SQL Server 資料庫 dbcreator 固定伺服器角色、SharePoint 群組 [伺服器陣列管理員] 和伺服器上 Administrators 群組的成員。Verify that the user account that is performing this procedure is a member of the SQL Server database dbcreator fixed server role, the Farm Administrators SharePoint group, and Administrators group on the server.

  2. 檢閱<SharePoint 2013 的硬體及軟體需求Review Hardware and software requirements for SharePoint 2013

  3. 安裝作業系統,並確定符合下列條件:Install the operating system, and make sure that the following conditions are satisfied:

    • 磁碟設定與現有的伺服器相同。The disk configuration is the same as the existing server.

    • 作業系統已更新為與現有伺服器相同的 Service Pack 或 Hotfix 版本。The operating system is updated to the same service pack or hotfix level as the existing server.

  4. 安裝與現有伺服器陣列資料庫伺服器上相同的 SQL Server 版本。Install the same version of SQL Server that is installed on the existing farm database server.

    如需有關 SQL Server 2008 R2 Service Pack 1 (SP1) 或 SQL Server 2012 在新增至現有伺服器陣列前如何經過安裝和設定的詳細資訊,請參閱<SQL Server 安裝 (SQL Server 2008 R2)>或<SQL Server 2012 快速入門安裝>。For information about how to install and configure SQL Server 2008 R2 with Service Pack 1 (SP1) or SQL Server 2012 before you add them to an existing server farm, see SQL Server Installation (SQL Server 2008 R2)orQuick-Start Installation of SQL Server 2012.

  5. 設定 SQL Server 並確認下列幾點:Configure SQL Server, and confirm the following:

    • 資料庫定序是 LATIN1_General_CI_AS_KS_WS。The database collation is LATIN1_General_CI_AS_KS_WS.

    • 已建立 SharePoint 2013 安裝程式使用者帳戶的登入帳戶。此帳戶將成為新資料庫的資料庫擁有者。A logon account is created for the SharePoint 2013 Setup user account. This account will be the database owner for the new database.

  6. 安裝現有資料庫伺服器上已安裝的相同 SQL Server Service Pack 和 Hotfix。Install the same SQL Server service packs and hotfixes that are installed on the existing database server.

設定並使用新的資料庫伺服器Configure and use the new database server

請參考下列程序,設定新的資料庫伺服器來裝載特定的 SharePoint 資料庫。其中包括下列步驟:Use the following procedures as a guide to configure a new database server to host specific SharePoint databases. This includes the following:

  • 建立新的 Web 應用程式。Create a new web application.

  • 移動網站集合到新的伺服器。Move a site collection to the new server.

您可以使用 SharePoint 管理中心網站或 Microsoft PowerShell來建立新的 Web 應用程式。您必須使用 PowerShell 來移動網站集合。You can use either the SharePoint Central Administration website or Microsoft PowerShell to create a new web application. You must use PowerShell to move a site collection.

若要建立新的 Web 應用程式To create a new web application

  1. 確認執行此程序的使用者帳戶是 SQL Server 資料庫 dbcreator 固定伺服器角色和 SharePoint 群組 [伺服器陣列管理員] 的成員。Verify that the user account that is performing this procedure is a member of the SQL Server database dbcreator fixed server role and the Farm Administrators SharePoint group.

  2. 使用 SharePoint 管理中心網站的 [應用程式管理] 頁面來建立新的網站。Use the Application Management page in the SharePoint Central Administration website to create a new web site.

  3. 設定傳統模式驗證 (Windows 驗證) 或宣告型驗證。Configure either classic mode authentication (Windows authentication) or claims-based authentication.

  4. 設定 IIS 來使用現有的網站,或建立新的網站並進行下列設定:Configure IIS to use either the existing web site or create a new web site and configure the following settings:

    • 指定您要用來存取 Web 應用程式的連接埠號碼。Specify the port number that you want to use to access the web application.

    • 提供您要用來存取 Web 應用程式的 URL (選用)。Provide the URL you want to use to access the web application (optional).

    • 提供伺服器上將網站裝載於的網站目錄路徑。Provide the path of the site directory on the server where the web site is hosted.

  5. 使用下列選項設定 Web 的驗證和加密。Configure authentication and encryption for your web by using the following options.

    • 交涉 (Kerberos) 或 NTLM 驗證。Negotiate (Kerberos) or NTLM authentication

    • 匿名存取網站Anonymous access to the web site

    • Secure Sockets Layer (SSL)Secure Sockets Layer (SSL)

  6. 針對使用者在此 Web 應用程式中將存取之所有網站的網域名稱,提供 URL。Provide a URL for the domain name for all sites that users will access in this web application.

  7. 使用現有的應用程式集區,或建立新的應用程式集區。Use the existing application pool or create a new one.

  8. 設定應用程式集區 (不論是預先定義或可設定之應用程式集區) 的安全性。Configure security for the application pool (predefined or configurable).

  9. 識別新 Web 應用程式的資料庫伺服器、資料庫名稱與驗證方法。Identify the database server, database name, and authentication method for your new web application.

如需詳細指示,請參閱<建立 web 應用程式 (SharePoint 2013)>。For detailed instruction, see Create a web application (SharePoint 2013).

藉由使用 PowerShell 移除網站集合To move a site collection by using PowerShell

  1. SharePoint 2013 內容資料庫會儲存伺服器陣列的所有網站內容,包括網站集合在內。內容資料庫可以儲存多個網站集合。無論是在資料庫伺服器之間或在資料庫之間移動網站集合,程序都一樣。如果網站集合變得太大,您可以使用相同的程序將它移至新的內容資料庫。The SharePoint 2013 content database stores all site content for a farm, this includes the site collection. Content databases can store more than one site collection. Whether you move a site collection between database servers or between databases the procedure is the same. If the site collection grows too large then it can be moved to a new content database using the same procedure.

  2. 確認您具備下列成員身分:Verify that you have the following memberships:

    • SQL Server 執行個體上的 securityadmin 固定伺服器角色。securityadmin fixed server role on the SQL Server instance.

    • 所有要更新之資料庫上的 db_owner 固定資料庫角色。db_owner fixed database role on all databases that are to be updated.

    • 正在執行 PowerShell Cmdlet 之所在伺服器上的系統管理員群組。Administrators group on the server on which you are running the PowerShell cmdlets.

      管理員可以使用 Add-SPShellAdmin Cmdlet 授與使用 SharePoint 2013 Cmdlet 的權限。如需 PowerShell 權限的其他資訊,請參閱< Add-SPShellAdmin>。An administrator can use the Add-SPShellAdmin cmdlet to grant permissions to use SharePoint 2013 cmdlets. For additional information about PowerShell permissions, see Add-SPShellAdmin.

  3. 確定以下條件成立:Verify that the following conditions are true:

    • 目的地內容資料庫存在。The destination content database exists.

    • 來源內容資料庫和目的地內容資料庫位於同一個 SQL Server 執行個體上。The source content database and destination content database reside on the same instance of SQL Server.

    • 來源內容資料庫和目的地內容資料庫已附加至同一個 Web 應用程式。The source content database and destination content database are attached to the same web application.

  4. 判斷來源網站集合的大小,確認目的地硬碟上的可用空間至少是該網站集合所需空間的三倍。Determine the size of the source site collection and verify that the destination hard disk has at least three times more free space than is required for the site collection.

    使用 Get-SPSiteAdministration Cmdlet 判斷網站集合的大小。如需詳細資訊,請參閱<Get-SPSiteAdministrationUse the Get-SPSiteAdministration cmdlet to determine the size of a site collection. For more information, see Get-SPSiteAdministration

  5. 使用 Move-SPSite Cmdlet 將網站集合從來源內容資料庫移動至新的內容資料庫。如需詳細資訊,請參閱< Move-SPSite>。Use the Move-SPSite cmdlet to move a site collection from the source content database to the new content database. For more information, see Move-SPSite.

    如需詳細資訊,請參閱<在 SharePoint Server 的資料庫間移動網站集合>。For detailed instructions, see Move site collections between databases in SharePoint Server.

另請參閱See also

其他資源Other Resources

部署 Windows Server 2008 R2Deploy Windows Server 2008 R2

安裝及部署 Windows Server 2012Install and Deploy Windows Server 2012

SQL Server 安裝 (SQL Server 2008 R2)SQL Server Installation (SQL Server 2008 R2)

安裝 SQL Server 2012Install SQL Server 2012