How to create an additional content database for a sharepoint web application

Run the following commands from powershell

1) Get-SPWebapplication - This command gets you a list of web applications in the farm

2) Create an additional content database for one of these webapplications

New-SPContentDatabase DemoContentDB -DatabaseServer SP2010 -WebApplication http://sp2010:1000/

3) Let us check in SQL if the database is created.

4) The database is listed .

5) Now to confirm the database is attached to the correct webapplication, browse to Central Admin->Manage Conetnt Database->Select the desired application

The new database is attached to the web application