SharePoint Management Center Configuration content database

The content database configured in SharePoint Management Center is the core of the Organization data in SharePoint2010. All website content information, such as documents, list data, and Web Part attributes. By default, parameters set in the content database may not be the best for your organization. Fortunately, these parameters can be modified to meet your needs. It is important to know which modifications can be made and the consequences of modifications. This article will teach you how to understand these parameters and make possible modifications. Preparation: Make sure you are the field administrator. Start: 1. Open Management Center-database-manage content database. 2. Click the content database to be modified. You can modify the following parameters: database information, database version and upgrade, failover server, database capacity settings, search server, delete content database, and the preferred server for running timer jobs. 3. Modify the settings and click OK. Working principle: 1. database information: including database status information. The drop-down list allows you to change its status. When the content database is offline, it is not available and you cannot create a site.
2. Failover server: Newly introduced in SharePoint 2010. The input server name does not set the Failover server. It tells SharePoint which database server to use if needed.
3. database capacity settings: control the number of website sets that can be created by the content database. There is a warning level, which must be smaller than the maximum number of websites that can be created.
4. Search server: The Search server used by the content database. According to your environment, there may be more than one server in the drop-down list.
5. delete a content database: allows you to revoke the content database association of a Web application. The content database is not deleted from SQL Server. Data is still available. The website cannot access any content contained in the content database.
6. The preferred server for running timer jobs: In SharePoint 2010, we can use a server for the timer job. This server is specially used for content databases.