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

I have a very large content database & need to split it. Is it possible to split a content database within a site collection? or I need to create a new site collection?

share|improve this question
add comment

3 Answers

up vote 12 down vote accepted

It is not possible to have multiple content databases service a single site collection. You would need to find a way to actually migrate the content from your one site collection to multiple site collections.

In situations where there is a single site collection that holds a bunch of sub-sites, such as in an Intranet scenario, I would look at moving the sub-site content to individual site collections for those departments.

In situations where you are doing large scale document management, I would look to use something like the Content Organizer to move the content to a series of back end site collections and content databases and then provide easy search and content roll up features to make the experience as easy and transparent as possible.

To handle the content moves required for either scenario you could either:

  • Move the content manually
  • Write custom code or powershell scripts to move the content from source to destination
  • Use a third party migration tool that can move the content from source to destination
share|improve this answer
    
Or look at using RBS to offload content to the filesystem and out of the content database. –  PirateEric Nov 16 '11 at 17:17
    
Good call @PirateEric but RBS is not a perfect fix for all situations. It doesn't always improve performance, and may add substantial complexity. –  Mike Oryszak Nov 16 '11 at 17:36
1  
agreed, I assume this question is in response to his previous question about loading 100GB of pictures into a library. RBS would be a worthwhile consideration in that regard. –  PirateEric Nov 16 '11 at 17:46
    
@MikeOryszak One Word "WOW!".Thx –  saumilm Nov 17 '11 at 6:44
    
The 200 Gb limit still applies with RBS. RBS can be a good solution for cheaper storage, but don't count on it to make your collaboration content DBs any bigger. –  Jorge Carvalho Nov 22 '11 at 21:58
show 3 more comments

You could not split the site collection into multiple content databases.

You can only move your site collection to a new content DB, or export sub sites and make them a new site collection.

share|improve this answer
add comment

Your Answer

 
discard

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.