Nothing too complicated today but something that some people aren’t aware of and ask if it can be done – having more than one content database so they can, for example, keep sensitive data separate from their general day to day content.
It’s simple enough to create multiple content databases in Central Administration:
Within Application Management, click the Manage Content Databases link. This will take you to the /_admin/CNTDBADM.aspx page.
From that page, click the Add a content database link. Ensure the Web Application is set to the one where you want new site collection to be created in, fill in the new content database form and click OK. After a short while your new content database will be ready to use.
There are a couple of ways to setup the content database as the default database for new site collections. The first is: