部分內容資料庫變得太大 (SharePoint Server)Some content databases are growing too large (SharePoint Server)

摘要:了解如何解決 SharePoint Server 2016 和 SharePoint 2013 中的 SharePoint Health Analyzer 規則「部分內容資料庫變得太大」。Summary: Learn how to resolve the SharePoint Health Analyzer rule "Some content databases are growing too large", in SharePoint Server 2016 and SharePoint 2013.

規則名稱:部分內容資料庫變得太大。Rule Name: Some content databases are growing too large.

摘要: 內容資料庫已成長到大於 100 GB。大型內容資料庫可能很難備份和還原。當您執行會影響整個資料庫的操作時,也很可能會導致應用程式停止回應。Summary: The content databases have grown larger than 100 gigabytes (GB). Large content databases can be difficult to back up and restore. They are also more likely to cause the application to stop responding when you perform operations that affect entire databases.

原因: 內容資料庫超過 100 GB。Cause: Content databases exceed 100 GB.

解決方案:編輯規則定義以防止將新網站新增至這些資料庫,然後將一些網站集合移動至其他資料庫。Resolution: Edit the rule definition to prevent new sites from being added to these databases, and then move some site collections to other databases.

  1. 確認執行此程序的使用者帳戶為伺服器陣列管理員群組的成員。Verify that the user account that is performing this procedure is a member of the Farm Administrators group.

  2. 在 SharePoint 管理中心網站上按一下 [監視]。On the SharePoint Central Administration website, click Monitoring.

  3. 按一下 [監視] 頁面的 [狀況分析器] 區段的 [檢閱規則定義]。On the Monitoring page, in the Health Analyzer section, click Review rule definitions.

  4. 在 [狀況分析規則定義] 頁面的 [可用性] 類別中,按一下 [規則的名稱。On the Health Analyzer Rule Definitions page, in the Availability category, click the name of the rule.

  5. 在 [狀況分析規則定義] 對話方塊中,按一下 [編輯項目,然後選取 [自動修復] 核取方塊。In the Health Analyzer Rule Definitions dialog box, click Edit Item, and then select the Repair Automatically check box.

  6. 按一下 [儲存]。您無法再可以超過 100 GB 的資料庫加入新網站。Click Save. You can no longer add new sites to databases that exceed 100 GB.

  7. 請將一些網站集合移動至較小的資料庫。如需詳細資訊,請參閱<在 SharePoint Server 的資料庫間移動網站集合>。Move some site collections to smaller databases. For more information, see Move site collections between databases in SharePoint Server.