SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 2 down vote accepted

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.

share|improve this answer
what should i set for warning? – Karthikeyan Mar 1 '11 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. – Eric Alexander Mar 1 '11 at 13:11

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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