Share via

Manage content databases (Office SharePoint Server)

  • Article

Applies To: Office SharePoint Server 2007

This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.

 

Content databases contain the content of sites in a Web application. Content databases are managed by using the Manage Content Databases page:

  1. On the top navigation bar, click Application Management.

  2. On the Application Management page, in the SharePoint Web Application Management section, click Content databases.

What do you want to do?

  • Add a content database to a Web application

  • Configure content database settings

  • Remove a content database from a Web application

Add a content database to a Web application

  1. On the Manage Content Databases page, click Add a content database.

  2. If the Web application to which you want to add a content database to is not selected, on the Add Content Database page, in the Web Application section, click Change Web Application on the Web Application menu.

  3. On the Select Web Application page, click the Web application to which you want to add the content database.

  4. In the Database Name and Authentication section, in the Database Server box, type the name of the database server that will host the content database. Using the default name is recommended in most cases.

  5. In the Database Name box, type a name for the content database. Using the default name is recommended in most cases.

  6. Under Database authentication, select one of the following:

    • Windows authentication (recommended)

    • SQL authentication   If you select this option, in the Account and Password boxes, type the account credentials to use for SQL authentication.

  7. In the Search Server section, in the Select Windows SharePoint Services search server list, select a search server for this database to use.

  8. In the Database Capacity Settings section, in the Number of sites before a warning event is generated box, type a value for the number of sites that can be created before a warning is generated.

  9. In the Maximum number of sites that can be created in this database box, type a value for the maximum number of sites that this database can host.

  10. Click OK.

The Operation in Progress page opens while the database is created. After the database is created, the Manage Content Databases page reappears. The new content database is displayed in the content database list.

Configure content database settings

For information about configuring content database settings, see Configure content database settings (Office SharePoint Server).

Remove a content database from a Web application

  1. On the Manage Content Databases page, click the content database that you want to remove.

  2. On the Manage Content Database Settings page, in the Remove Content Database section, select the Remove content database check box.

    • If any sites are currently using this database, a message box appears. Click OK to indicate that you want to proceed with the removal.

  3. Click OK.