Here is the scenario: Your intranet is growing fast and you decided to implement a policy that will limit number of sites that will be created per content database in SQL. Default value is 15000 sites per content database and backup and restore operations on such a large size may be very long and the way out of the box backup tool for SharePoint work – make large size databases locked. It’d be way more efficient to have the number of sites something less than 15000, so how do you go about it?
1. Access your central administration and switch to Application Management tab
2. Select content databases
3. You will see number of databases – in our case it’s just one, number of sites allowed to be created are highlighted:
4. Here you can add a new content database and edit available properties of the existing. It’s fairly straight forward how you can change the number of sites per database.
Hope this helps, here are some more usefull articles:
Add, split, and merge content databases
Using Microsoft Windows SharePoint Services with a content database
