SharePoint 資料庫支援的高可用性和災害復原選項Supported high availability and disaster recovery options for SharePoint databases

摘要:了解支援高可用性和嚴重損壞修復每個 SharePoint 伺服器 2016年及 SharePoint 2013 系統及服務應用程式資料庫。Summary: Learn about supported high availability and disaster recovery options for each SharePoint Server 2016 and SharePoint 2013 system and service application database.

本文說明支援高可用性和嚴重損壞修復的 SharePoint Server 資料庫。如需這些資料庫,如大小和支援的備份及復原工具的詳細資訊請參閱資料庫類型與 SharePoint Server 中的描述This article describes the supported high availability and disaster recovery options for SharePoint Server databases. For detailed information about these databases, such as size and supported backup and recovery tools, see Database types and descriptions in SharePoint Server.

簡介Introduction

本文的範圍會支援高可用性和嚴重損壞修復解決方案的每個 SharePoint Server 的系統及服務應用程式資料庫。這些解決方案解決資料庫層級,而不是資料庫執行個體或資料庫伺服器層級,如下所示: 資料庫鏡像資料庫可用性群組,並記錄傳送。The scope of this article is the supported high availability and disaster recovery solutions for each SharePoint Server system and service application database. These solutions address the database level, instead of the database instance or database server level and include the following: database mirroring, database availability groups, and log shipping.

當您評估 SharePoint 的高可用性或災害復原時,必須知道因為設計需求和功能特性,並非每個 SharePoint 資料庫皆支援所有選項。When you evaluate a high availability or a disaster recovery option for SharePoint, you must understand that not all of the options are supported by each SharePoint database. This is because of design requirements and feature characteristics.

本文會識別每個 SharePoint 資料庫支援的選項。這些資料庫是先以 SKU 分組,再以功能分組。This article identifies the supported option for each SharePoint database. These databases are grouped by SKU and then by feature.

SharePoint Server 系統資料庫SharePoint Server system databases

設定、 管理中心內容、 及內容資料庫是當您部署任何 SharePoint 2013 版本,並使用 MinRole 功能任何 SharePoint Server 2016 伺服器角色會自動安裝的資料庫。如需詳細資訊,請參閱MinRole 描述和 SharePoint Server 2016 中相關聯的服務The Configuration, Central Administration Content, and Content databases are the databases that are automatically installed when you deploy any SharePoint 2013 edition, and any SharePoint Server 2016 server role using the MinRole feature. For more information, see Description of MinRole and associated services in SharePoint Server 2016.

下表提供 SharePoint 系統資料庫支援的高可用性和災害復原。The following tables provide the supported high availability and disaster recovery options for the SharePoint system databases.

設定資料庫Configuration database

類別Category 描述Description
使用 [SharePoint 產品設定精靈] 安裝時的預設資料庫名稱Default database name when it is installed with the SharePoint Products Configuration Wizard
SharePoint_ConfigSharePoint_Config
用途Purpose
設定資料庫包含 SharePoint 資料庫、 網際網路資訊服務 (IIS) 網站、 web 應用程式、 受信任解決方案、 網頁組件封裝及網站範本的相關資料。The configuration database contains data about SharePoint databases, Internet Information Services (IIS) web sites, web applications, Trusted solutions, Web Part packages, and Site templates.
設定資料庫也包含 SharePoint 伺服器陣列設定,例如預設配額設定和封鎖的檔案類型的特定資料。The configuration database also contains specific data for SharePoint Server farm settings, such as default quota settings and blocked file types.
支援與 Service Pack 1 (SP1) 和 SQL Server 2016 RTM 同步鏡像的可用性伺服器陣列中的 SQL Server 2014Supports SQL Server 2014 with Service Pack 1 (SP1) and SQL Server 2016 RTM synchronous mirroring in a farm for availability
支援伺服器陣列中的 SQL Server 2008 R2 和 SQL Server 2012 同步鏡像以取得可用性Supports SQL Server 2008 R2 and SQL Server 2012 synchronous mirroring in a farm for availability
Yes
支援 SQL Server AlwaysOn 可用性群組使用同步認可以取得可用性Supports SQL Server AlwaysOn Availability Group with synchronous-commit for availability
Yes
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM asynchronous mirroring or log-shipping to another farm for disaster recovery
支援 SQL Server 2008 R2 非同步鏡像或記錄傳送至其他伺服器陣列以取得災害復原Supports SQL Server 2008 R2 asynchronous mirroring or log-shipping to another farm for disaster recovery
否。這是伺服器陣列特定資料庫。No. This is a farm specific database.
支援 SQL Server AlwaysOn 可用性群組使用非同步認可以取得災害復原Supports SQL Server AlwaysOn Availability Group with asynchronous-commit for disaster recovery
否。這是伺服器陣列特定資料庫。No. This is a farm specific database.

管理中心內容資料庫Central Administration content database

類別Category 描述Description
使用 [SharePoint 產品設定精靈] 安裝時的預設資料庫名稱Default database name when it is installed with the SharePoint Products Configuration Wizard
SharePoint_AdminContent_<GUID>SharePoint_AdminContent_<GUID>
用途Purpose
此資料庫可儲存管理中心網站集合的所有組態的資料。如果已安裝 SQL Server 2016 RTM、 Power Pivot for SharePoint Server 2016 或 SQL Server 2012 Power Pivot for SharePoint 2013 管理中心內容資料庫也會儲存 Excel Online and Excel 工作表和 Power Pivot 資料檔案的使用中Power Pivot 管理儀表板。This database stores all configuration data for the Central Administration site collection. If SQL Server 2016 RTM, Power Pivot for SharePoint Server 2016 or SQL Server 2012 Power Pivot for SharePoint 2013 is installed the Central Administration content database also stores the Excel Online and Excel worksheets and Power Pivot data files that are used in the Power Pivot Management Dashboard.
附註:Power Pivot for SharePoint Server 2016 只有與 SQL Server 2016 rtm 版本。Note: Power Pivot for SharePoint Server 2016 is only available with SQL Server 2016 RTM.
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 同步鏡像的可用性伺服器陣列中Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM synchronous mirroring in a farm for availability
支援伺服器陣列中的 SQL Server 2008 R2 和 SQL Server 2012 同步鏡像以取得可用性Supports SQL Server 2008 R2 and SQL Server 2012 synchronous mirroring in a farm for availability
Yes
支援 SQL Server AlwaysOn 可用性群組使用同步認可以取得可用性Supports SQL Server AlwaysOn Availability Group with synchronous-commit for availability
Yes
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM asynchronous mirroring or log-shipping to another farm for disaster recovery
支援 SQL Server 2008 R2 與 SQL Server 2012 的非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2008 R2 and SQL Server 2012 asynchronous mirroring or log-shipping to another farm for disaster recovery
否。這是伺服器陣列特定資料庫。No. This is a farm specific database.
支援 SQL Server AlwaysOn 可用性群組使用非同步認可以取得災害復原Supports SQL Server AlwaysOn Availability Group with asynchronous-commit for disaster recovery
否。這是伺服器陣列特定資料庫。No. This is a farm specific database.

內容資料庫Content database

類別Category 描述Description
使用 [SharePoint 產品設定精靈] 安裝時的預設資料庫名稱Default database name when it is installed with the SharePoint Products Configuration Wizard
WSS_ContentWSS_Content
用途Purpose
內容資料庫儲存網站集合的所有內容。包含文件庫中的網站文件或檔案、清單資料、網頁組件屬性、稽核記錄,以及一些 SharePoint 資料的應用程式 (若有安裝應用程式),但使用者名稱和權限則不包含在內。Content databases store all content for a site collection. This includes site documents or files in document libraries, list data, Web Part properties, audit logs, and some apps for SharePoint data if the apps are installed, in addition to user names and rights.
若安裝 SharePoint Server 環境中內容資料庫也會儲存使用者資料的 SQL Server 2016 CTP 3.1 或更新版本、 Power Pivot for SharePoint Server 2016 和 SQL Server 2012 Power Pivot for SharePoint 2013。此外內容資料庫也會儲存在 SharePoint Server 2016 的 Project Server 2016 延伸模組。Content databases also store user data for SQL Server 2016 CTP 3.1 or later, Power Pivot for SharePoint Server 2016 and SQL Server 2012 Power Pivot for SharePoint 2013, if you installed it in your SharePoint Server environment. Additionally Content databases also store the Project Server 2016 extensions in SharePoint Server 2016.
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 同步鏡像的可用性伺服器陣列中Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM synchronous mirroring in a farm for availability
支援伺服器陣列中的 SQL Server 2008 R2 和 SQL Server 2012 同步鏡像以取得可用性Supports SQL Server 2008 R2 and SQL Server 2012 synchronous mirroring in a farm for availability
Yes
支援 SQL Server AlwaysOn 可用性群組使用同步認可以取得可用性Supports SQL Server AlwaysOn Availability Group with synchronous-commit for availability
Yes
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM asynchronous mirroring or log-shipping to another farm for disaster recovery
支援 SQL Server 2008 R2 與 SQL Server 2012 的非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2008 R2 and SQL Server 2012 asynchronous mirroring or log-shipping to another farm for disaster recovery
Yes
支援 SQL Server AlwaysOn 可用性群組使用非同步認可以取得災害復原Supports SQL Server AlwaysOn Availability Group with asynchronous-commit for disaster recovery
Yes

SharePoint Server 2016 服務應用程式資料庫SharePoint Server 2016 service application databases

所有的 SharePoint Server 2016 服務應用程式儲存特定資料及物件的唯一的資料庫或系統資料庫。這些資料庫被建立為支援 SharePoint Server 2016 伺服器陣列中所使用的功能。All SharePoint Server 2016 service applications store specific data and objects in either a unique database or a system database. These databases are created to support features that are used in SharePoint Server 2016 farms.

下列各節說明支援的高可用性和嚴重損壞修復 SharePoint Server 2016 服務應用程式資料庫。The following sections describe the supported high availability and disaster recovery options for SharePoint Server 2016 service application databases.

App Management Service 應用程式App Management service application

下表提供應用程式管理資料庫支援的高可用性和災害復原。The following table provides the supported high availability and disaster recovery options for the App Management database.

應用程式管理資料庫App Management database

類別Category 描述Description
使用 [SharePoint 產品設定精靈] 安裝時的預設資料庫名稱Default database name when it is installed with the SharePoint Products Configuration Wizard
2016年:AppMng_Service_DB_<GUID>2016: AppMng_Service_DB_<GUID>
2013年:AppManagement2013: AppManagement
用途Purpose
儲存從 SharePoint 市集或應用程式目錄下載的應用程式授權和權限。Stores app licenses and permissions that are downloaded from the SharePoint Store or App Catalog.
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 同步鏡像的可用性伺服器陣列中Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM synchronous mirroring in a farm for availability
支援伺服器陣列中的 SQL Server 2008 R2 和 SQL Server 2012 同步鏡像以取得可用性Supports SQL Server 2008 R2 and SQL Server 2012 synchronous mirroring in a farm for availability
Yes
支援 SQL Server AlwaysOn 可用性群組使用同步認可以取得可用性Supports SQL Server AlwaysOn Availability Group with synchronous-commit for availability
Yes
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM asynchronous mirroring or log-shipping to another farm for disaster recovery
支援 SQL Server 2008 R2 與 SQL Server 2012 的非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2008 R2 and SQL Server 2012 asynchronous mirroring or log-shipping to another farm for disaster recovery
Yes
支援 SQL Server AlwaysOn 可用性群組使用非同步認可以取得災害復原Supports SQL Server AlwaysOn Availability Group with asynchronous-commit for disaster recovery
Yes

Business Data Connectivity Service 資料庫Business Data Connectivity service database

下表說明 Business Data Connectivity 資料庫支援的高可用性和災害復原。The following table describes the supported high availability and disaster recovery options for the Business Data Connectivity database.

Business Data Connectivity Service 資料庫Business Data Connectivity service database

類別Category 描述Description
使用 [SharePoint 產品設定精靈] 安裝時的預設資料庫名稱Default database name when it is installed with the SharePoint Products Configuration Wizard
Bdc_Service_DB_<GUID>Bdc_Service_DB_<GUID>
用途Purpose
儲存外部內容類型及相關物件。Stores external content types and related objects.
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 同步鏡像的可用性伺服器陣列中Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM synchronous mirroring in a farm for availability
支援伺服器陣列中的 SQL Server 2008 R2 和 SQL Server 2012 同步鏡像以取得可用性Supports SQL Server 2008 R2 and SQL Server 2012 synchronous mirroring in a farm for availability
Yes
支援 SQL Server AlwaysOn 可用性群組使用同步認可以取得可用性Supports SQL Server AlwaysOn Availability Group with synchronous-commit for availability
Yes
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM asynchronous mirroring or log-shipping to another farm for disaster recovery
支援 SQL Server 2008 R2 與 SQL Server 2012 的非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2008 R2 and SQL Server 2012 asynchronous mirroring or log-shipping to another farm for disaster recovery
Yes
支援 SQL Server AlwaysOn 可用性群組使用非同步認可以取得災害復原Supports SQL Server AlwaysOn Availability Group with asynchronous-commit for disaster recovery
Yes

Managed Metadata Service 資料庫Managed Metadata Service database

下表說明 Managed Metadata Service 資料庫支援的高可用性和災害復原。The following table describes the supported high availability and disaster recovery options for the Managed Metadata Service database.

Managed Metadata Service 資料庫Managed Metadata Service database

類別Category 描述Description
使用 [SharePoint 產品設定精靈] 安裝時的預設資料庫名稱Default database name when it is installed with the SharePoint Products Configuration Wizard
2016年:受管理的中繼資料服務 <GUID>2016: Managed Metadata Service<GUID>
2013年:受管理的中繼資料服務 Application_Metadata_<GUID>2013: Managed Metadata Service Application_Metadata_<GUID>
用途Purpose
儲存受管理的中繼資料及同步處理內容類型。Stores managed metadata and syndicated content types.
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 同步鏡像的可用性伺服器陣列中Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM synchronous mirroring in a farm for availability
支援伺服器陣列中的 SQL Server 2008 R2 和 SQL Server 2012 同步鏡像以取得可用性Supports SQL Server 2008 R2 and SQL Server 2012 synchronous mirroring in a farm for availability
Yes
支援 SQL Server AlwaysOn 可用性群組使用同步認可以取得可用性Supports SQL Server AlwaysOn Availability Group with synchronous-commit for availability
Yes
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM asynchronous mirroring or log-shipping to another farm for disaster recovery
支援 SQL Server 2008 R2 與 SQL Server 2012 的非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2008 R2 and SQL Server 2012 asynchronous mirroring or log-shipping to another farm for disaster recovery
Yes
支援 SQL Server AlwaysOn 可用性群組使用非同步認可以取得災害復原Supports SQL Server AlwaysOn Availability Group with asynchronous-commit for disaster recovery
Yes

注意

Managed Metadata Service 是分類法服務。The Managed Metadata Service is the Taxonomy service.

PerformancePoint Services 資料庫PerformancePoint Services database

下表說明 PerformancePoint Services 資料庫支援的高可用性和災害復原。The following table describes the supported high availability and disaster recovery options for the PerformancePoint Services database.

PerformancePoint Services 資料庫PerformancePoint Services database

類別Category 描述Description
使用 [SharePoint 產品設定精靈] 安裝時的預設資料庫名稱Default database name when it is installed with the SharePoint Products Configuration Wizard
2016年:PerformancePoint Service Application_<GUID>2016: PerformancePoint Service Application_<GUID>
2013年:PerformancePoint 服務 <GUID>2013: PerformancePoint Service<GUID>
用途Purpose
儲存暫時物件及儲存的使用者註解和設定。Stores temporary objects and saved user comments and settings.
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 同步鏡像的可用性伺服器陣列中Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM synchronous mirroring in a farm for availability
支援伺服器陣列中的 SQL Server 2008 R2 和 SQL Server 2012 同步鏡像以取得可用性Supports SQL Server 2008 R2 and SQL Server 2012 synchronous mirroring in a farm for availability
Yes
支援 SQL Server AlwaysOn 可用性群組使用同步認可以取得可用性Supports SQL Server AlwaysOn Availability Group with synchronous-commit for availability
Yes
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM asynchronous mirroring or log-shipping to another farm for disaster recovery
支援 SQL Server 2008 R2 與 SQL Server 2012 的非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2008 R2 and SQL Server 2012 asynchronous mirroring or log-shipping to another farm for disaster recovery
Yes
支援 SQL Server AlwaysOn 可用性群組使用非同步認可以取得災害復原Supports SQL Server AlwaysOn Availability Group with asynchronous-commit for disaster recovery
Yes

Power Pivot 服務資料庫Power Pivot Service database

下表說明支援的高可用性和嚴重損壞修復Power Pivot服務資料庫。The following table describes the supported high availability and disaster recovery options for the Power Pivot Service database.

注意

Power Pivot for SharePoint Server 2016 才有 SQL Server 2016 CTP 3.1 或更新版本。Power Pivot for SharePoint Server 2016 is only available with SQL Server 2016 CTP 3.1 or later.

注意

Power Pivot for SharePoint 2013 只有使用 SQL Server 2012 SP1 Analysis Services (SSAS)。Power Pivot for SharePoint 2013 is only available with SQL Server 2012 SP1 Analysis Services (SSAS).

Power Pivot 服務資料庫Power Pivot Service database

類別Category 描述Description
預設資料庫名稱與Power Pivot for SharePoint組態工具] 安裝時Default database name when it is installed with the Power Pivot for SharePoint Configuration Tool
DefaultPowerPivotServiceApplicationDB_<GUID>DefaultPowerPivotServiceApplicationDB_<GUID>
用途Purpose
儲存的資料重新整理排程,以及供內部使用的活頁簿使用狀況資料Power Pivot服務應用程式。Stores data refresh schedules, and workbook usage data for internal use by Power Pivot service applications.
支援 SQL Server 2016 RTM 同步鏡像的可用性伺服器陣列中Supports SQL Server 2016 RTM synchronous mirroring in a farm for availability
支援伺服器陣列中的 SQL Server 2008 R2 和 SQL Server 2012 同步鏡像以取得可用性Supports SQL Server 2008 R2 and SQL Server 2012 synchronous mirroring in a farm for availability
是,但是不建議使用。請改用同步認可模式中的 AlwaysOn。Yes, but not recommended. Use AlwaysOn in Synchronous-Commit Mode instead.
支援可用性同步認可模式SQL Server AlwaysOn 可用性群組Supports SQL Server AlwaysOn Availability Group in Synchronous-Commit Mode for availability
是,建議使用。Yes, recommended.
支援 SQL Server 2016 RTM 非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2016 RTM asynchronous mirroring or log-shipping to another farm for disaster recovery
支援 SQL Server 2008 R2 與 SQL Server 2012 的非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2008 R2 and SQL Server 2012 asynchronous mirroring or log-shipping to another farm for disaster recovery
Yes
支援 SQL Server AlwaysOn 可用性群組使用非同步認可以取得災害復原Supports SQL Server AlwaysOn Availability Group with asynchronous-commit for disaster recovery
Yes

Project Server 資料庫Project Server database

重要

Project Server 服務應用程式資料庫只是 SharePoint Server 2013 中找到。Project Server 2016 不會建立資料庫的 SharePoint Server 2016,但是使用的內容資料庫 (WSS_Content)。The Project Server service application database is only found in SharePoint Server 2013. Project Server 2016 doesn't create a database for SharePoint Server 2016 but uses the Content database (WSS_Content).

下表說明 Project Server 資料庫支援的高可用性和災害復原。The following table describes the supported high availability and disaster recovery options for the Project Server database.

注意

Project Server 會建立每個 Project Web App 執行個體的個別資料庫Project Server creates a separate database for each instance of Project Web App

Project Server 資料庫Project Server database

類別Category 描述Description
使用 [SharePoint 產品設定精靈] 安裝時的預設資料庫名稱Default database name when it is installed with the SharePoint Products Configuration Wizard
ProjectWebAppProjectWebApp
用途Purpose
每個 Project Web App 資料庫皆包含下列資料:Each Project Web App database contains the following data:
所有 Project 產品組合管理 (PPM) 資料All Project and Portfolio Management (PPM) data
時間追蹤及時程表資料Time tracking and Timesheet data
SharePoint 專案網站彙總資料Aggregated SharePoint project site data
支援伺服器陣列中的 SQL Server 2008 R2 和 SQL Server 2012 同步鏡像以取得可用性Supports SQL Server 2008 R2 and SQL Server 2012 synchronous mirroring in a farm for availability
Yes
支援 SQL Server AlwaysOn 可用性群組使用同步認可以取得可用性Supports SQL Server AlwaysOn Availability Group with synchronous-commit for availability
Yes
支援 SQL Server 2008 R2 與 SQL Server 2012 的非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2008 R2 and SQL Server 2012 asynchronous mirroring or log-shipping to another farm for disaster recovery
Yes
支援 SQL Server AlwaysOn 可用性群組使用非同步認可以取得災害復原Supports SQL Server AlwaysOn Availability Group with asynchronous-commit for disaster recovery
Yes

SharePoint Search Service 資料庫SharePoint Search service databases

SharePoint Search Service 應用程式使用下列資料庫:The SharePoint Search service application uses the following databases:

  • 搜尋管理Search Administration

  • 分析報告Analytics Reporting

  • 編目Crawl

  • 連結Link

下表提供搜尋資料庫支援的高可用性和災害復原。The following tables provide the supported high availability and disaster recovery options for the Search databases.

搜尋管理資料庫Search Administration database

類別Category 描述Description
使用 [SharePoint 產品設定精靈] 安裝時的預設資料庫名稱Default database name when it is installed with the SharePoint Products Configuration Wizard
Search_Service_Application_DB_<GUID>Search_Service_Application_DB_<GUID>
用途Purpose
儲存搜尋應用程式設定以及編目元件的系統存取控制清單 (SACL)。Stores the Search application configuration and system access control list (SACL) for the crawl component.
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 同步鏡像的可用性伺服器陣列中Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM synchronous mirroring in a farm for availability
支援伺服器陣列中的 SQL Server 2008 R2 和 SQL Server 2012 同步鏡像以取得可用性Supports SQL Server 2008 R2 and SQL Server 2012 synchronous mirroring in a farm for availability
Yes
支援 SQL Server AlwaysOn 可用性群組使用同步認可以取得可用性Supports SQL Server AlwaysOn Availability Group with synchronous-commit for availability
Yes
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM asynchronous mirroring or log-shipping to another farm for disaster recovery
支援 SQL Server 2008 R2 與 SQL Server 2012 的非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2008 R2 and SQL Server 2012 asynchronous mirroring or log-shipping to another farm for disaster recovery
否。支援取得搜尋管理資料庫的複本,並使用它來重新建立搜尋服務應用程式。No. Taking a copy of the Search Administration database and using it to re-create the Search service application is supported.
支援 SQL Server AlwaysOn 可用性群組使用非同步認可以取得災害復原Supports SQL Server AlwaysOn Availability Group with asynchronous-commit for disaster recovery
否。支援取得搜尋管理資料庫的複本,並使用它來重新建立搜尋服務應用程式。No. Taking a copy of the Search Administration database and using it to re-create the Search service application is supported.

分析報告資料庫Analytics Reporting database

類別Category 描述Description
使用 [SharePoint 產品設定精靈] 安裝時的預設資料庫名稱Default database name when it is installed with the SharePoint Products Configuration Wizard
Search_Service_Application_AnalyticsReportingStoreDB_<GUID>Search_Service_Application_AnalyticsReportingStoreDB_<GUID>
用途Purpose
儲存流量分析報告的結果,以及視需要從連結資料庫擷取資訊。Stores the results for usage analysis reports and extracts information from the Link database when it is needed.
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 同步鏡像的可用性伺服器陣列中Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM synchronous mirroring in a farm for availability
支援伺服器陣列中的 SQL Server 2008 R2 和 SQL Server 2012 同步鏡像以取得可用性Supports SQL Server 2008 R2 and SQL Server 2012 synchronous mirroring in a farm for availability
Yes
支援 SQL Server AlwaysOn 可用性群組使用同步認可以取得可用性Supports SQL Server AlwaysOn Availability Group with synchronous-commit for availability
Yes
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM asynchronous mirroring or log-shipping to another farm for disaster recovery
支援 SQL Server 2008 R2 與 SQL Server 2012 的非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2008 R2 and SQL Server 2012 asynchronous mirroring or log-shipping to another farm for disaster recovery
Yes
支援 SQL Server AlwaysOn 可用性群組使用非同步認可以取得災害復原Supports SQL Server AlwaysOn Availability Group with asynchronous-commit for disaster recovery
No

編目資料庫Crawl database

類別Category 描述Description
使用 [SharePoint 產品設定精靈] 安裝時的預設資料庫名稱Default database name when it is installed with the SharePoint Products Configuration Wizard
Search_Service_Application_CrawlStoreDB_<GUID>Search_Service_Application_CrawlStoreDB_<GUID>
用途Purpose
儲存編目資料及編目記錄狀態。Stores the state of the crawled data and the crawl history.
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 同步鏡像的可用性伺服器陣列中Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM synchronous mirroring in a farm for availability
支援伺服器陣列中的 SQL Server 2008 R2 和 SQL Server 2012 同步鏡像以取得可用性Supports SQL Server 2008 R2 and SQL Server 2012 synchronous mirroring in a farm for availability
Yes
支援 SQL Server AlwaysOn 可用性群組使用同步認可以取得可用性Supports SQL Server AlwaysOn Availability Group with synchronous-commit for availability
Yes
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM asynchronous mirroring or log-shipping to another farm for disaster recovery
支援 SQL Server 2008 R2 與 SQL Server 2012 的非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2008 R2 and SQL Server 2012 asynchronous mirroring or log-shipping to another farm for disaster recovery
No
支援 SQL Server AlwaysOn 可用性群組使用非同步認可以取得災害復原Supports SQL Server AlwaysOn Availability Group with asynchronous-commit for disaster recovery
No

連結資料庫Link database

類別Category 描述Description
使用 [SharePoint 產品設定精靈] 安裝時的預設資料庫名稱Default database name when it is installed with the SharePoint Products Configuration Wizard
Search_Service_Application_LinkStoreDB_<GUID>Search_Service_Application_LinkStoreDB_<GUID>
用途Purpose
儲存內容處理元件擷取的資訊以及點選連結資訊。Stores the information that is extracted by the content processing component and click through information.
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 同步鏡像的可用性伺服器陣列中Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM synchronous mirroring in a farm for availability
支援伺服器陣列中的 SQL Server 2008 R2 和 SQL Server 2012 同步鏡像以取得可用性Supports SQL Server 2008 R2 and SQL Server 2012 synchronous mirroring in a farm for availability
Yes
支援 SQL Server AlwaysOn 可用性群組使用同步認可以取得可用性Supports SQL Server AlwaysOn Availability Group with synchronous-commit for availability
Yes
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM asynchronous mirroring or log-shipping to another farm for disaster recovery
支援 SQL Server 2008 R2 與 SQL Server 2012 的非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2008 R2 and SQL Server 2012 asynchronous mirroring or log-shipping to another farm for disaster recovery
No
支援 SQL Server AlwaysOn 可用性群組使用非同步認可以取得災害復原Supports SQL Server AlwaysOn Availability Group with asynchronous-commit for disaster recovery
No

Secure Store 資料庫Secure Store database

下表提供安全認證儲存資料庫支援的高可用性和災害復原。The following table provides the supported high availability and disaster recovery options for the Secure Store database.

Secure Store 資料庫Secure Store database

類別Category 描述Description
使用 [SharePoint 產品設定精靈] 安裝時的預設資料庫名稱Default database name when it is installed with the SharePoint Products Configuration Wizard
Secure_Store_Service_DB_<GUID>Secure_Store_Service_DB_<GUID>
用途Purpose
儲存及比對認證,例如帳戶名稱和密碼。Stores and maps credentials, such as account names and passwords.
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 同步鏡像的可用性伺服器陣列中Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM synchronous mirroring in a farm for availability
支援伺服器陣列中的 SQL Server 2008 R2 和 SQL Server 2012 同步鏡像以取得可用性Supports SQL Server 2008 R2 and SQL Server 2012 synchronous mirroring in a farm for availability
Yes
支援 SQL Server AlwaysOn 可用性群組使用同步認可以取得可用性Supports SQL Server AlwaysOn Availability Group with synchronous-commit for availability
Yes
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM asynchronous mirroring or log-shipping to another farm for disaster recovery
支援 SQL Server 2008 R2 與 SQL Server 2012 的非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2008 R2 and SQL Server 2012 asynchronous mirroring or log-shipping to another farm for disaster recovery
Yes
支援 SQL Server AlwaysOn 可用性群組使用非同步認可以取得災害復原Supports SQL Server AlwaysOn Availability Group with asynchronous-commit for disaster recovery
Yes

SharePoint Translation Services 資料庫SharePoint Translation Services database

下表說明翻譯服務資料庫支援的高可用性和災害復原。The following table describes the supported high availability and disaster recovery options for the Translation Services database.

翻譯服務資料庫Translation Services database

類別Category 描述Description
使用 [SharePoint 產品設定精靈] 安裝時的預設資料庫名稱Default database name when it is installed with the SharePoint Products Configuration Wizard
2016年:TranslationService_<GUID>2016: TranslationService_<GUID>
2013年:SharePoint 翻譯 Services_<GUID>2013: SharePoint Translation Services_<GUID>
用途Purpose
儲存已啟用副檔名之擱置及完成的批次翻譯文件資訊。Stores information about pending and completed batch document translations with enabled file name extensions.
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 同步鏡像的可用性伺服器陣列中Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM synchronous mirroring in a farm for availability
支援伺服器陣列中的 SQL Server 2008 R2 和 SQL Server 2012 同步鏡像以取得可用性Supports SQL Server 2008 R2 and SQL Server 2012 synchronous mirroring in a farm for availability
Yes
支援 SQL Server AlwaysOn 可用性群組使用同步認可以取得可用性Supports SQL Server AlwaysOn Availability Group with synchronous-commit for availability
Yes
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM asynchronous mirroring or log-shipping to another farm for disaster recovery
支援 SQL Server 2008 R2 與 SQL Server 2012 的非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2008 R2 and SQL Server 2012 asynchronous mirroring or log-shipping to another farm for disaster recovery
Yes
支援 SQL Server AlwaysOn 可用性群組使用非同步認可以取得災害復原Supports SQL Server AlwaysOn Availability Group with asynchronous-commit for disaster recovery
Yes

State Service 資料庫State Service database

下表說明 State Service 資料庫支援的高可用性和災害復原。The following table describes the supported high availability and disaster recovery options for the State Service database.

State Service 資料庫State Service database

類別Category 描述Description
使用 [SharePoint 產品設定精靈] 安裝時的預設資料庫名稱Default database name when it is installed with the SharePoint Products Configuration Wizard
2016年:StateService_<GUID>2016: StateService_<GUID>
2013年:SessionStateService_<GUID>2013: SessionStateService_<GUID>
用途Purpose
儲存 InfoPath Forms Services、Exchange Server、圖表網頁組件和 Visio Services 的暫時狀態資訊。Stores temporary state information for InfoPath Forms Services, Exchange Server, the chart Web Part, and Visio Services.
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 同步鏡像的可用性伺服器陣列中Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM synchronous mirroring in a farm for availability
支援伺服器陣列中的 SQL Server 2008 R2 和 SQL Server 2012 同步鏡像以取得可用性Supports SQL Server 2008 R2 and SQL Server 2012 synchronous mirroring in a farm for availability
Yes
支援 SQL Server AlwaysOn 可用性群組使用同步認可以取得可用性Supports SQL Server AlwaysOn Availability Group with synchronous-commit for availability
Yes
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM asynchronous mirroring or log-shipping to another farm for disaster recovery
支援 SQL Server 2008 R2 與 SQL Server 2012 的非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2008 R2 and SQL Server 2012 asynchronous mirroring or log-shipping to another farm for disaster recovery
No
支援 SQL Server AlwaysOn 可用性群組使用非同步認可以取得災害復原Supports SQL Server AlwaysOn Availability Group with asynchronous-commit for disaster recovery
No

訂閱設定服務應用程式Subscription Settings service application

下表提供訂閱設定服務應用程式資料庫支援的高可用性和災害復原。The following table provides the supported high availability and disaster recovery options for the Subscription Settings service application database.

訂閱設定資料庫Subscription Settings database

類別Category 描述Description
使用 [SharePoint 產品設定精靈] 安裝時的預設資料庫名稱Default database name when it is installed with the SharePoint Products Configuration Wizard
SettingsServiceDBSettingsServiceDB
用途Purpose
託管客戶的儲存功能和設定。Stores features and settings for hosted customers.
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 同步鏡像的可用性伺服器陣列中Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM synchronous mirroring in a farm for availability
支援伺服器陣列中的 SQL Server 2008 R2 和 SQL Server 2012 同步鏡像以取得可用性Supports SQL Server 2008 R2 and SQL Server 2012 synchronous mirroring in a farm for availability
Yes
支援 SQL Server AlwaysOn 可用性群組使用同步認可以取得可用性Supports SQL Server AlwaysOn Availability Group with synchronous-commit for availability
Yes
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM asynchronous mirroring or log-shipping to another farm for disaster recovery
支援 SQL Server 2008 R2 與 SQL Server 2012 的非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2008 R2 and SQL Server 2012 asynchronous mirroring or log-shipping to another farm for disaster recovery
Yes
支援 SQL Server AlwaysOn 可用性群組使用非同步認可以取得災害復原Supports SQL Server AlwaysOn Availability Group with asynchronous-commit for disaster recovery
Yes

Usage and Health Data Collection 資料庫Usage and Health Data Collection database

下表提供 Usage and Health Data Collection 資料庫支援的高可用性和災害復原。The following table provides the supported high availability and disaster recovery options for the Usage and Health Data Collection database.

Usage and Health Data Collection 資料庫Usage and Health Data Collection database

類別Category 描述Description
使用 [SharePoint 產品設定精靈] 安裝時的預設資料庫名稱Default database name when it is installed with the SharePoint Products Configuration Wizard
2016年:Wss_logging 形式2016: WSS_Logging
2013年:SharePoint_Logging2013: SharePoint_Logging
用途Purpose
暫時儲存狀況監視和流量資料,並且可用於報告及診斷。Stores health monitoring and usage data temporarily, and can be used for reporting and diagnostics.
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 同步鏡像的可用性伺服器陣列中Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM synchronous mirroring in a farm for availability
支援伺服器陣列中的 SQL Server 2008 R2 和 SQL Server 2012 同步鏡像以取得可用性Supports SQL Server 2008 R2 and SQL Server 2012 synchronous mirroring in a farm for availability
是,但是不建議Yes, but not recommended
支援 SQL Server AlwaysOn 可用性群組使用同步認可以取得可用性Supports SQL Server AlwaysOn Availability Group with synchronous-commit for availability
附註:您不可以執行 PSConfig、 (SharePoint 產品設定精靈或 Microsoft PowerShell) 時要套用 SharePoint sharepoing 累計更新此資料庫是一律在可用性群組的成員。Note: It is not possible to run PSConfig, (SharePoint Products Configuration Wizard or Microsoft PowerShell) to apply SharePoint CUs when this database is a member of an Always On Availability Group.
是,但是不建議Yes, but not recommended
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM asynchronous mirroring or log-shipping to another farm for disaster recovery
支援 SQL Server 2008 R2 與 SQL Server 2012 的非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2008 R2 and SQL Server 2012 asynchronous mirroring or log-shipping to another farm for disaster recovery
是,但是不建議Yes, but not recommended
支援 SQL Server AlwaysOn 可用性群組使用非同步認可以取得災害復原Supports SQL Server AlwaysOn Availability Group with asynchronous-commit for disaster recovery
否。這是伺服器陣列特定資料庫。不過,您可以將它複製至災害復原環境,以進行資料採礦。No. This database is farm specific. However, you can copy it to a disaster recovery environment for data mining.

User Profile Service 資料庫User Profile Service databases

User Profile Service 應用程式使用下列資料庫:The User Profile Service application uses the following databases:

  • 設定檔:設定檔資料庫可儲存及管理使用者及相關資訊,也可儲存使用者的社交網路資訊,以及通訊群組清單和網站中的成員資格資訊。Profile: The Profile database stores and manages users and associated information. It also stores information about a user's social network in addition to memberships in distribution lists and sites.

  • 同步處理:同步處理資料庫可儲存設定及臨時資料,以用於同步處理設定檔資料與 Active Directory 等目錄服務。Synchronization: The Synchronization database stores configuration and staging data for use when profile data is being synchronized with directory services such as Active Directory.

  • 社交標記:社交標記資料庫可儲存使用者建立的社交標記與記事,以及其各自的 URL。Social Tagging: The Social Tagging database stores social tags and notes created by users, alongside their respective URLs.

下表說明 User Profile Service 應用程式資料庫支援的高可用性和災害復原。The following tables describe the supported high availability and disaster recovery options for the User Profile service application databases.

設定檔資料庫Profile database

類別Category 描述Description
使用 [SharePoint 產品設定精靈] 安裝時的預設資料庫名稱Default database name when it is installed with the SharePoint Products Configuration Wizard
User Profile Service Application_ProfileDB_<GUID>User Profile Service Application_ProfileDB_<GUID>
用途Purpose
儲存及管理使用者及其相關資訊,也可儲存使用者的社交網路資訊,以及通訊群組清單和網站中的成員資格資訊。Stores and manages users and their associated information. It also stores information about a user's social network in addition to memberships in distribution lists and sites.
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 同步鏡像的可用性伺服器陣列中Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM synchronous mirroring in a farm for availability
支援伺服器陣列中的 SQL Server 2008 R2 和 SQL Server 2012 同步鏡像以取得可用性Supports SQL Server 2008 R2 and SQL Server 2012 synchronous mirroring in a farm for availability
Yes
支援 SQL Server AlwaysOn 可用性群組使用同步認可以取得可用性Supports SQL Server AlwaysOn Availability Group with synchronous-commit for availability
Yes
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM asynchronous mirroring or log-shipping to another farm for disaster recovery
支援 SQL Server 2008 R2 與 SQL Server 2012 的非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2008 R2 and SQL Server 2012 asynchronous mirroring or log-shipping to another farm for disaster recovery
Yes
支援 SQL Server AlwaysOn 可用性群組使用非同步認可以取得災害復原Supports SQL Server AlwaysOn Availability Group with asynchronous-commit for disaster recovery
Yes

同步處理資料庫Synchronization database

類別Category 描述Description
使用 [SharePoint 產品設定精靈] 安裝時的預設資料庫名稱Default database name when it is installed with the SharePoint Products Configuration Wizard
User Profile Service Application_SyncDB_<GUID>User Profile Service Application_SyncDB_<GUID>
用途Purpose
儲存設定及臨時資料,以用於同步處理設定檔資料與 Active Directory 等目錄服務。Stores configuration and staging data for use when profile data is synchronized with directory services such as Active Directory.
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 同步鏡像的可用性伺服器陣列中Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM synchronous mirroring in a farm for availability
支援伺服器陣列中的 SQL Server 2008 R2 和 SQL Server 2012 同步鏡像以取得可用性Supports SQL Server 2008 R2 and SQL Server 2012 synchronous mirroring in a farm for availability
Yes
支援 SQL Server AlwaysOn 可用性群組使用同步認可以取得可用性Supports SQL Server AlwaysOn Availability Group with synchronous-commit for availability
Yes
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM asynchronous mirroring or log-shipping to another farm for disaster recovery
支援 SQL Server 2008 R2 與 SQL Server 2012 的非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2008 R2 and SQL Server 2012 asynchronous mirroring or log-shipping to another farm for disaster recovery
No
支援 SQL Server AlwaysOn 可用性群組使用非同步認可以取得災害復原Supports SQL Server AlwaysOn Availability Group with asynchronous-commit for disaster recovery
No

社交標記資料庫Social Tagging database

類別Category 描述Description
使用 [SharePoint 產品設定精靈] 安裝時的預設資料庫名稱Default database name when it is installed with the SharePoint Products Configuration Wizard
User Profile Service Application_SocialDB_<GUID>User Profile Service Application_SocialDB_<GUID>
用途Purpose
儲存使用者建立的社交標記與記事,以及其各自的 URL。Stores social tags and notes created by users, alongside their respective URLs.
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 同步鏡像的可用性伺服器陣列中Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM synchronous mirroring in a farm for availability
支援伺服器陣列中的 SQL Server 2008 R2 和 SQL Server 2012 同步鏡像以取得可用性Supports SQL Server 2008 R2 and SQL Server 2012 synchronous mirroring in a farm for availability
Yes
支援 SQL Server AlwaysOn 可用性群組使用同步認可以取得可用性Supports SQL Server AlwaysOn Availability Group with synchronous-commit for availability
Yes
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM asynchronous mirroring or log-shipping to another farm for disaster recovery
支援 SQL Server 2008 R2 與 SQL Server 2012 的非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2008 R2 and SQL Server 2012 asynchronous mirroring or log-shipping to another farm for disaster recovery
Yes
支援 SQL Server AlwaysOn 可用性群組使用非同步認可以取得災害復原Supports SQL Server AlwaysOn Availability Group with asynchronous-commit for disaster recovery
Yes

Word Automation Services 資料庫Word Automation Services database

下表說明 Word Automation Services 資料庫支援的高可用性和災害復原。The following table describes the supported high availability and disaster recovery options for the Word Automation Services database.

Word Automation Services 資料庫Word Automation Services database

類別Category 描述Description
使用 [SharePoint 產品設定精靈] 安裝時的預設資料庫名稱Default database name when it is installed with the SharePoint Products Configuration Wizard
WordAutomationServices_<GUID>WordAutomationServices_<GUID>
用途Purpose
儲存擱置及完成的文件轉換資訊。Stores information about pending and completed document conversions.
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 同步鏡像的可用性伺服器陣列中Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM synchronous mirroring in a farm for availability
支援伺服器陣列中的 SQL Server 2008 R2 和 SQL Server 2012 同步鏡像以取得可用性Supports SQL Server 2008 R2 and SQL Server 2012 synchronous mirroring in a farm for availability
Yes
支援 SQL Server AlwaysOn 可用性群組使用同步認可以取得可用性Supports SQL Server AlwaysOn Availability Group with synchronous-commit for availability
Yes
支援 SQL Server 2014 (SP1) 和 SQL Server 2016 RTM 非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2014 (SP1) and SQL Server 2016 RTM asynchronous mirroring or log-shipping to another farm for disaster recovery
支援 SQL Server 2008 R2 與 SQL Server 2012 的非同步鏡像或記錄傳送至其他伺服器陣列以取得嚴重損壞修復Supports SQL Server 2008 R2 and SQL Server 2012 asynchronous mirroring or log-shipping to another farm for disaster recovery
Yes
支援 SQL Server AlwaysOn 可用性群組使用非同步認可以取得災害復原Supports SQL Server AlwaysOn Availability Group with asynchronous-commit for disaster recovery
Yes

SQL Server 系統資料庫SQL Server System databases

SharePoint Server 內建於 SQL Server 並使用下列 SQL Server 系統資料庫: 主圖形、 msdb、 模型、 資源及 tempdb。SQL Server 提供一組完整的系統管理工具],可讓使用者完全管理其系統和管理所有使用者與在資料庫中的物件。如需 SQL Server 系統資料庫的詳細資訊,請參閱系統資料庫SharePoint Server is built on SQL Server and uses the following SQL Server system databases: master, msdb, model, Resource, and tempdb. SQL Server provides a complete set of administrative tools that let users fully administer their system and manage all users and objects in a database. For more information about the SQL Server system databases, see System Databases.

您只能鏡像使用者資料庫、將它們放置在 SQL Server AlwaysOn 可用性群組或記錄傳送。您無法使用這些方法提供系統資料庫的高可用性和災害復原。You can only mirror user databases, put them in a SQL Server AlwaysOn availability group or log ship them. You can't use these approaches to provide high availability or disaster recovery for the system databases.

SQL Server Reporting Services 資料庫SQL Server Reporting Services databases

下列 SQL Server Reporting Services 資料庫可以使用 SharePoint Server 部署的一部分:The following SQL Server Reporting Services databases can be used as part of a SharePoint Server deployment:

  • 報表伺服器目錄 (ReportingService_<GUID>) - 儲存所有報表中繼資料,包括報表定義、報表記錄和快照集,以及排程資訊。Report Server Catalog (ReportingService_<GUID>) - Stores all report metadata including report definitions, report history and snapshots, and scheduling information.

    注意

    若報表伺服器目錄已使用,報表文件會儲存於 SharePoint 內容資料庫中。When Report Server Catalog is used, report documents are stored in SharePoint content databases.

  • ReportServerTempDB (ReportingService_<GUID>TempDB) - 執行報表時儲存所有暫存快照。ReportServerTempDB (ReportingService<GUID>_TempDB) - Stores all the temporary snapshots while reports are running.

  • 報表伺服器警示 (ReportingService_<GUID>Alerting) - 儲存所有資料警示和執行階段資訊。Report Server Alerting (ReportingService<GUID>_Alerting) - Stores all Data Alerts and runtime information.

Reporting Services 報表伺服器是儲存兩個 SQL Server 關聯式資料庫中應用程式資料、內容、屬性及工作階段資訊的無狀態伺服器。若要確保 Reporting Services 功能的可用性,最佳方法是執行下列操作:A Reporting Services report server is a stateless server that stores application data, content, properties, and session information in two SQL Server relational databases. The best way to ensure the availability of Reporting Services functionality is to do the following:

  • 使用 SQL Server Database Engine 的高可用性功能,以最大化報表伺服器資料庫的執行時間。若您設定 Database Engine 執行個體在容錯叢集中加以執行,可以在建立報表伺服器資料庫時選取該執行個體。Use the high availability features of the SQL Server Database Engine to maximize the uptime of the report server databases. If you configure a Database Engine instance to run in a failover cluster, you can select that instance when you create a report server database.

  • 搭配 Reporting Services 資料庫,以及針對適用的資料來源,使用 SQL Server AlwaysOn 可用性群組。Use SQL Server AlwaysOn Availability Groups with the Reporting Services databases and for data sources where applicable.

  • 設定多部報表伺服器在一個擴充部署中執行,其中所有報表會共用單一報表伺服器資料庫。在不同伺服器上部署多個報表伺服器執行個體,可協助增加不間斷服務的等級。Configure multiple report servers to run in a scale-out deployment, where all the servers share a single report server database. Deploying multiple report server instances on different servers can help increase the level of uninterrupted service.

See alsoSee also

概念Concepts

資料庫類型與 SharePoint Server 中的描述Database types and descriptions in SharePoint Server

其他資源Other Resources

AlwaysOn 可用性群組 (SQL Server):與其他 Database Engine 功能的互通性和共存性AlwaysOn Availability Groups (SQL Server): Interoperability and Coexistence with Other Database Engine Features

資料庫鏡像: 互通性與共存Database Mirroring: Interoperability and Coexistence