Specifying Content Database Settings

Microsoft Office SharePoint Portal Server 2003 and Microsoft Windows SharePoint Services both use content databases to store content for individual sites. However, SharePoint Portal Server uses a different content database for each site, while Windows SharePoint Services uses a content database for multiple sites.

You can view the complete list of database settings for the server farm in the Database Server Settings section on the Configure Server Topology and Component Assignments page. An asterisk (*) next to the server name in the site settings entry indicates the default database server for the content database for the next portal site created. All servers that have stored the content database for previously-created portal sites are also listed.

Specify content database settings

1. On the SharePoint Portal Server Central Administration for Server server_name page, in the Server Configuration section, click Specify content database server.
2. On the Specify Content Database Settings page, do one of the following:
   • To use the same server for the content database that the configuration database server uses, select the Use same server as configuration database check box.

     By default, when you create a virtual server, SharePoint Portal Server stores a corresponding content database on the same server that contains the configuration database.

   • To specify a different server for the content database, clear the Use same server as configuration database check box, and then type the name of the new server in the Server name box.
3. Click OK.