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

If I have a web application which shares site collections with - for example - MySites, and other site collections (created with their specified content DB's) is it possible to control which content DB's the MySite Site Collections use? As they are created automatically, it makes it a bit hard to specify explicitly the content DB.


share|improve this question

If your mysite site collections are in the same web application as your other site collections, they will share content databases. Unfortunately there is no way in specifying which site collections go into which content databases.

This is one of the reasons people like to put mysites in a separate webapp. Nowadays, with the rise of "host named site collections" and them being actually usable now, that idea has perhaps lost some followers but it's still a valid approach.

If multiple content databases are assigned to a web app, a round robin mechanism will be used when creating sites. The only thing you can control here is specifying some content databases not to be used anymore (by setting the maximum number of sites), but that will be true no matter what site collection you create.

The "self service site creation" property is scoped at the webapp level, so you also can't do this at the individual content databases.

share|improve this answer
Thanks - yes that was my line of thinking - host named site collections. The round robin is not ideal as some my sites could end up in other sites content Dbs. Looks like MySites still needs to be in its own web application. :) – Russell Mar 5 '13 at 22:29
Self service site creation does not work with host named site collections. – Dennis G Jun 20 '13 at 18:17

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.