Share via

Some content databases are growing too large (SharePoint Server)

  • Article

APPLIES TO: yes-img-132013 yes-img-162016 yes-img-192019 yes-img-seSubscription Edition no-img-sopSharePoint in Microsoft 365

Rule Name: Some content databases are growing too large.

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.

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. 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, click Edit Item, and then select the Repair Automatically check box.

  6. Click Save. You can no longer add new sites to databases that exceed 100 GB.

  7. Move some site collections to smaller databases. For more information, see Move site collections between databases in SharePoint Server.