We are looking at the possibility of migrating 2TB+ worth of data from our network driving into SharePoint for a department site. For this question I'm assuming all data is valid and has the ability to be assigned to a custom content type and be given basic metadata.

If we did this, we would need to split the data between multiple site collections / content databases but ideally the user experience would be fairly seamless. Key functionality: - Users will be collaborating on about 5% of the content at any one time but we don’t currently have a way of determining what would be considered collaborative content and what would be classified as a record. Technically we do but I don’t believe the business is willing to do that on a document by document basis.

  • Users can browse to their content
  • Users can search for their content
  • As more content is added we will need to add additional content databases. Existing content may need to be moved to those content databases but the experience should stay constant. I.e., I’m trying to avoid the scenario of documents used to be in SiteA/DocLib1 but now you have to go to SiteB/DocLib1.


What concepts / whitepapers should be researched in order to evaluate this?

  • What version of SP and SQL server are you running, that might be beneficial. – Eric Alexander Apr 2 '13 at 18:19
  • SharePoint 2010 and SQL Server 2008 R2 – RWL01 Apr 2 '13 at 21:54

For such a large database, you should create site collection with separate content db. You can't do this through UI, so you have to create the structure programmatically.

You can refer following whitepaper: Managing Multi-Terabyte Content Databases with SharePoint 2010 (white paper)

Hope it helps!!

| improve this answer | |
  • Thanks for the information, it told me what I need to know which is unfortunately managing multi TBs is not really what SP does best. We've decided to push these requests into our Documentum system and referece that data through custom webparts in SP. – RWL01 May 3 '13 at 13:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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