How to configure a content database in SharePoint Central Administration

In SharePoint2010, a content database is the core of the organization's data. is a place where all site content information, such as documents, list data, and Web Part properties, is stored. By default, the parameters set by the content database may not be the best for your organization.

Fortunately, these parameters can be modified to suit your needs. It is important to know what can be modified and what the consequences of that change are. This article teaches you to understand these parameters and make possible changes.

Get ready:

Make sure you're a field administrator.

Begin:

1. Open the Management center-the database-to manage the content database.

2. Click the content database you want to modify. The parameters you can modify are: Database information, database version and upgrade, failover server, database capacity settings, search server, delete content database, and preferred server for running timer jobs.

3. Make the corresponding modification, click OK.

Working principle:

1. Database information: including database status information. The Drop-down list allows you to change its state. When the content database is offline, it is unavailable and the site cannot be created.

2. Failover server: Newly introduced in SharePoint 2010. Entering a server name does not set up a failover server. It tells SharePoint which database server to use if needed.

3. Database capacity setting: Controls the number of site collections that the content database can create. Has a warning level that must be less than the maximum number of sites to create.