在 SharePoint Server 中管理資料庫Manage databases in SharePoint Server

摘要:了解如何管理與 SharePoint Server 2016 和 SharePoint 2013 相關聯的資料庫。Summary: Learn how to manage the databases that are associated with SharePoint Server 2016 and SharePoint 2013.

下列文章與相關資源提供資料庫管理與 SharePoint Server 的資訊。The following articles on TechNet and related resources provide information about database management with SharePoint Server.

內容Content 描述Description
在 SharePoint Server 中新增內容資料庫Add content databases in SharePoint Server
將內容資料庫新增到現有的 Web 應用程式是十分常見的工作。本文將說明如何新增內容資料庫到現有的 SharePoint Server 實作。Adding a content database to an existing Web application is a common task. This article describes how to add a content database to an existing SharePoint Server implementation.
在 SharePoint Server 中附加或卸離內容資料庫Attach or detach content databases in SharePoint Server
某些操作 (如套用更新或是建立組態設定的複本) 會要求您先卸離再附加資料庫。本文將說明如何執行這些程序。Certain operations, such as applying updates or creating copies of configuration settings, require that you detach and then attach databases. This article describes how to do these procedures.
在 SharePoint Server 的資料庫間移動網站集合Move site collections between databases in SharePoint Server
在某些情況下,您可能會想要將一或多個網站集合移至不同的內容資料庫。例如,網站集合可能會因為不斷地增長,導致原有的內容資料庫無法再行容納,而須將網站集合移至較大的內容資料庫。反之,若網站集合並未增長到預期的容量,則將數個網站集合合併於一個內容資料庫內就十分方便。本文將說明如何在資料庫之間移動網站集合。Under some circumstances, you might want to move one or more site collections to a different content database. For example, a site collection can outgrow the content database on which it is located, and you would have to move the site collection to a larger content database. Conversely, if site collections do not grow to their expected capacity, it might be convenient to combine several site collections onto one content database. This article describes how to move site collections between databases.
在 SharePoint Server 中移動內容資料庫Move content databases in SharePoint Server
本文說明如何在執行 SQL Server 的伺服器之間、SQL Server 的執行個體之間,或 SharePoint Server Web 應用程式之間移動內容資料庫。您也可以移動內容資料庫,以負載平衡資料庫伺服器或 Web 應用程式。This article describes how to move content databases between servers that are running SQL Server, between instances of SQL Server, or from one SharePoint Server Web application to another. You can also move a content database to load balance a database server or Web application.
移動 SharePoint Server 中的所有資料庫Move all databases in SharePoint Server
本文說明如何將 SharePoint Server 支援的所有資料庫從一部資料庫伺服器移至另一部資料庫伺服器。如果您的 SharePoint 資料庫位於其他伺服器上,此程序可套用於主控設定資料庫的資料庫伺服器。This article describes how to move all of the databases supported by SharePoint Server from one database server to another database server. If your SharePoint databases are hosted on different servers, this procedure applies to the database server that hosts the configuration database.
在 SharePoint Server 中移動或重新命名服務應用程式資料庫Move or rename service application databases in SharePoint Server
了解如何使用 SQL Server 移動並重新命名服務應用程式資料庫,以及如何將服務應用程式指到已移動或已重新命名的資料庫。Learn how to move and rename service application databases by using SQL Server, and then how to point the service application to the moved or renamed database.
在 SharePoint Server 中執行使用唯讀資料庫的伺服器陣列Run a farm that uses read-only databases in SharePoint Server
唯讀的伺服器陣列可以是損壞修復環境的一部分,也可以是其他版本之伺服器陣列進行更新期間,提供使用者存取之高度可用的維護、修補或更新環境的一部分。本文將說明如何執行內容資料庫設成唯讀的 SharePoint Server 伺服器陣列 (唯讀伺服器陣列)。A read-only farm can be part of a disaster recovery environment. Alternatively, it can be part of a highly available maintenance, patching, or upgrade environment that provides user access while another version of the farm is being updated. This article describes how to run a SharePoint Server farm in which content databases are set to be read-only (a read-only farm).
在 SharePoint Server 中管理 RBSManage RBS in SharePoint Server
了解遠端 BLOB 儲存 (RBS) 以及如何在 SharePoint Server 中管理 RBS。Learn about Remote BLOB Storage (RBS) and how to manage RBS in SharePoint Server.
針對 SharePoint 伺服器陣列 SQL Server 的最佳作法Best practices for SQL Server in a SharePoint Server farm
了解關於 SharePoint Server 伺服器陣列中 SQL Server 的最佳做法。Learn about best practices for SQL Server in a SharePoint Server farm.

另請參閱See also

概念Concepts

SharePoint Server 的備份與復原概觀Overview of backup and recovery in SharePoint Server

在 SharePoint Server 中規劃備份和修復Plan for backup and recovery in SharePoint Server

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