Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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

1 Answer 1

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. –  PirateEric 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.