We have two content databases in a webapplication. We would like to have a site collection in a content database (Content_DB1) and rest of the site collection should be created in the another content database (Content_DB2).

The content database (Content_DB1) should have only one site collection at all time.

Is that possible in SharePoint 2010? if so, how?

1 Answer 1


In Central Adninistration, Content_DB1 should just be set to ready and have a max number of sites set to 1, then every other site collection will be created in Content_DB2.

  • what should i set for warning? Mar 1, 2011 at 2:00
  • What ever you deem appropriate. As an admin though, you'll be creating site collections and have easy access to Central Admin to see how the content databases are doing. You'll be able to easily provision a new one if Content_DB2 is getting too large. Mar 1, 2011 at 13:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.