How to create and correlate content databases to specified Web applications and site collections in SharePoint

A Web application is not limited to using a single content database. SharePoint allows you to correlate multiple content databases to Web applications. One reason is based on the size of the content database. If it is greater than 200G, it makes sense to divide it into two content databases.

Another consideration is the type of data in the content database. If a marketing site contains pictures and videos, it is reasonable to create a content database for this site collection data only. Another example is to create a content database for the legal department to keep all legal data.

Finally, there is the benefit of disaster recovery. Knowing where your data is and what the structure is can be more efficient, useful, and flexible in applying a disaster recovery strategy.

This article teaches you to create multiple content databases to a Web application and apply the appropriate site collection to the corresponding content database.

Get ready:

Make sure you are a farm administrator and must have the correct permissions to create the database.

Begin:

1. Open the Management Center, under the application management, the database section, click Manage Content database.

2. Click Add Content Database link.

3. The database name defaults to the GUID suffix. Modify database name wss_content_marketing. The rest defaults. Note naming to conform to naming conventions.

4. To ensure that the site collection is added to the appropriate content database, make sure you are still managing the content Database page.

5. Click the content database for the site collection that you do not want to add to.

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/web/sharepoint/