Tuesday, April 29, 2014

Prevent new sites to be added to content databases in SharePoint 2013

In this post we will discuss how we can prevent new sites to be added to content databases that grows more in database size.

Also you can check out:

- What happen when you press F5 in Visual Studio in SharePoint 2013?

- Create new site group in SharePoint 2013

- Create Apps using Office 365 development tools Napa

Suppose the content databases have grown larger than 100 gigabytes (GB). Large content databases can be difficult to back up and restore. And sometimes this causes the application to stop responding when you perform operations that affect entire databases.

Here we can edit the rule definition to prevent new sites from being added to these databases.

We can do this from SharePoint Central Administration.

Open SharePoint Central Administration, On the Monitoring page, in the Health Analyzer section, click Review rule definitions.

Then 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.

Twitter Delicious Facebook Digg Favorites More