What is the recommended approach when a single site collection (on a Content Database) is growing above the 200 GB limit?

All files are stored in the same site collection, within different sites and document libraries. Most of the contents are office files.

I want to keep the files indexed and searchable. And maintainable doing backup and restore.

2 Answers 2


To manage site collection size growth, I would recommend to create an Archive site collection (with separate Content database). Use the primary site collection to store only "actual" data.


  • Create an additional site collection that contains archive data
  • Implement archiving process for moving expired data into archive

About archiving process

Information management policies is a no-code solution for implementing archiving process in SharePoint. Setup a Retention policy with action Transfer to another location


Create and apply information management policies

Managing Information Management Policy in SharePoint Server 2010 (ECM)


You ought to break your content up into new site collections and content databases. This can be accomplished by creating new empty site collections within new empty content DBs and migrating content (webs) to your new site collections. You may also consider creating a new (or modifying existing) managed paths in order to maintain legacy links to your content. It's a big job, but definitely doable.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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