Creating Additional Content Databases (Windows SharePoint Services 2.0)

  • Article

Windows SharePoint Services can store site data across multiple content databases. The deployment by the Internet Platform and Operations group includes two SQL Server clusters, each of which can host a Windows SharePoint Services content database, so this deployment uses a second content database.

Add a content database

  1. Click Start, click All Programs, point to Administrative Tools, and then click SharePoint Central Administration.

  2. In the Virtual Server Configuration section, click Configure virtual server settings.

  3. Click the virtual server you want to configure.

  4. In the Virtual Server Management section, click Manage content databases.

  5. Click Add a content database.

  6. In the Database Information section, click Specify database server settings and type the database server and the database name.

  7. In the Database Capacity Settings section, type the values you want to use. The value in the Number of sites before a warning event is generated box should be about 90 percent of the value in the Maximum number of sites that can be created in this database box. For more information about determining database capacity settings, see "Managing Content Databases" in the Windows SharePoint Services Administrator's Guide.

  8. Click OK.

    Note

    The STSAdminAcct account must be a member of the DB Creation and Security Administrator server roles on the SQL Server database you specify.