SharePoint has been one of the most challenging applications I have had to administer to date. I often find myself needing to perform a common task over and over again, but having to relearn how I accomplished it the last time. It is kind of an illogical interface, but it gets the job done
One of those somewhat common tasks, since we just recent began to implement SharePoint, is creating a site collection in a new content database. Unfortunately, you can not specify the content database to use when you are creating the site. This, I hope will be address in a future release.
How SharePoint assigns a Content Database to a Site Collection
SharePoint distributes site collections based on the number of sites already assigned to a Content Database.
Content Database A has five Site Collections and Content Database B has four Site Collections. SharePoint will automatically drop the next Site Collection in Content Database B because it has the fewest Site Collections.
We can use this feature to our advantage should we want to create a Site Collection in it’s owe Content Database by creating a new Content Database first and then create a new Site Collection. The new Content Database will have zero Site Collections, thereby forcing the new Site Collection to use the new Content Database.
How to Create a New Content Database using the Central Administration Console
1) Click on Application Management in the left pane.
2) Under Databases, click on Manage Content Databases.
3) On the Right, verify the correct Web Application is selected.
4) Click on Add a Content Database.
5) Enter the SQL Server name and the name for the new Content Database
6) Fill in remaining information as desired and click OK.
6) Go back to Application Management and Create Site Collections into the same Web Application that you just created the Content Database for.
Your new site collection will now be storing it’s data in the Content Database you just created. You can verify this by choosing View all Site Collections from the Application Management page.
There are ways of performing these actions using the SharePoint Management Console, but those will have to wait for another post.