I had an interview today with a senior technical person. One of the question he asked regarding content datrabase size. He insisted that he could split a single site collection into multiple content databases and he has been doing that all the time. This was a big surprise to me and I did more search on line, I found the same answer as I knoew before: you can not split a single site collection into multiple content database. However, you can convert a sub site into a new site collection which is on a different content database. But I don't think this is waht he ment. Since I was still in the shock (sort of in a funny way), I decide to post this question here for the experts to help me clear out my mind and make sure I really know what I am doing. Thank you very much.

My understanding is the same. The only way you could do this is to create the SC then create subsites and have those subsites on sperate contentent DB. You could not have the same site split. i think maybe he meant he was adding sites and they were on seperate DB's Anyway, just because they are Sr. does not make them smarter...

Thanks for your answer. As far as I know, new sub sites will go with the site collection which will stay which ever it is. SharePoint does not put new sub site into new content database just because the original is off line. If this is not correct, please let me know.

I was thinking he was moving the subsites, not just placing them in an DB. I don't see how you can place them in another DB on creation without custom coding this. You can choose your DB for a site collection, but not a subsite. In 2003 this is another story. We did have sub sites on seperate databases. I may be wrong here...I would like to here as well now that you got me confused

LOL That's bolderdash, can't be done. You can split the content database into multiple files for performance reasons, but you can't have a site collection spanning multiple databases. End of... :-)

You know what's awesome about that? I have a site collection right now that has a sub site that has a very large list that currently sits in 2 different content db's... and no it's not an orphan. Proposed resolution??? Backup entire 25.6gb site collection.. Restore to a lab environment and verify that it works correctly... Delete production site and verify that both content db's do not contain that subsite anymoreCreate the site again in productionRestore the backup over the newly created site with the -overwrite commandverify that site only exists in single content db

THUMB RULE ========one site collection = single databaseI LOVE MS..... Warm Regards, Kshitiz Posting is provided "AS IS" with no warranties, and confers no rights.

I believe i know what he meant now. Its not the splitting via the sharepoint but via the sql database to manage the entire content database into various manageable parts, E.g. splitting up the database into parts of 50 gb each, but when the database is read it is considered as one database instead multiple files. Hope I've kinda got this right, am gonna try this soon.

I believe i know what he meant now. Its not the splitting via the sharepoint but via the sql database to manage the entire content database into various manageable parts, E.g. splitting up the database into parts of 50 gb each, but when the database is read it is considered as one database instead multiple files. Hope I've kinda got this right, am gonna try this soon. Hi there, I am curious to know the result of this test. Do you think this is a reasonable way to get over the 100GB limit of content databases? Regards, P.-- PMDCI, Master in BA, PRINCE2, ITILv2, MCP, MCTS (SharePoint), MBSS (Dynamics CRM), VTSP 4

The only way you could do this is to create the SC then create subsites and have those subsites on sperate contentent DB. You could not have the same site split. i think maybe he meant he was adding sites and they were on seperate DB's Are you sure this is possible? You mean that I could, under the SAME site collection, specify different a different content database for each sub-site? My understanding is that this is NOT possible... -- PMDCI, Master in BA, PRINCE2, ITILv2, MCP, MCTS (SharePoint), MBSS (Dynamics CRM), VTSP 4