Add a content database (Office SharePoint Server 2007)
Updated: August 7, 2008
Applies To: Office SharePoint Server 2007
You can use the following procedures to add a new content database to a server.
Add a database to a Web application
In the user interface, use this procedure to create a new database and assign it to a SharePoint Web application.
Before you begin, check that you know the name of the database server used for the farm you are connecting to.
The account used to restore the databases must be a member of the Administrators group on the local computer and the SQL Server dbcreator fixed server role to complete the following procedure.
Add a database to a Web application by using the user interface
Start the SharePoint Central Administration Web site.
On the Application Management page, in the SharePoint Web Application Management section, click Content databases.
On the Manage Content Databases page, click Add a content database.
On the Add Content Database page:
Select a Web application for the new database.
Select a database server to host the new database.
Specify the authentication method the new database will use and supply an account name and password if necessary.
Specify both the total number of top-level sites that can be created in the database and the number at which a warning will be issued.
Use the following procedure to create a new database and assign it to a SharePoint Web application by using the Stsadm command line tool.
You must be a member of the Administrators group on the local server computer and the SQL Server dbcreator fixed server role to complete the following procedure.
Add a database to a Web application by using the Stsadm command-line tool
At a command prompt on the drive where SharePoint Products and Technologies is installed, change to the following directory:
%COMMONPROGRAMFILES%\Microsoft Shared\Web server extensions\12\Bin
Type the following command, and then press ENTER: Stsadm -o addcontentdb -url <URL name> -databasename <database name>
where url is the URL of the Web application to which the content database is being added and database name is the name of the database that you want to add.
For more information, see Addcontentdb: Stsadm operation (Office SharePoint Server).