Add a content database

Add a content database (Office SharePoint Server 2007)

Good article From MS on "how 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.

Important:
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

1. Start the SharePoint Central Administration Web site.
   
2. On the Application Management page, in the SharePoint Web Application Management section, click Content databases.
   
3. On the Manage Content Databases page, click Add a content database.
   
4. On the Add Content Database page:
   
   1. Select a Web application for the new database.
      
   2. Select a database server to host the new database.
      
   3. Specify the authentication method the new database will use and supply an account name and password if necessary.
      
   4. 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.
      
5. Click OK.
   

Use the following procedure to create a new database and assign it to a SharePoint Web application by using the Stsadm command line tool.

Important:
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

1. 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
   
2. Type the following command, and then press ENTER:Stsadm -o addcontentdb -url-databasename
   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).