Some content databases are growing too large (SharePoint Server 2010)
Published: December 6, 2011
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.
Verify that the user account that is performing this procedure is a member of the Farm Administrators group.
On the Central Administration Home page, click Monitoring.
On the Monitoring page, in the Health Analyzer section, click Review rule definitions.
On the Health Analyzer Rule Definitions page, in the Availability category, click the name of the rule.
In the Health Analyzer Rule Definitions dialog box, click Edit Item, and then select the Repair Automatically check box.
Click Save. You can no longer add new sites to databases that exceed 100 GB.
Move some site collections to smaller databases. For more information, see Move site collections between databases (SharePoint Server 2010).
December 6, 2011