Creating a Site Collection in a Specific Content Database
To force SharePoint to create new site collections in a specific content database, the target database should be the only one with the Ready status; all the other databases associated with the web application should be set Offline.
Taking a database offline means that from this point on, no new site collection will be created in that database. However, the database is still usable; users can still upload and download content, view web pages, and process workflows, and new subsites under an existing site collection can still be created in it. If a one-to-one site collection to content database association is needed, taking the hosting database offline is a method to accomplish this.
Get Microsoft SharePoint 2010 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.