Why is my content database so large?

Posted by PeterBrunone on ASP.net Weblogs See other posts from ASP.net Weblogs or by PeterBrunone
Published on Tue, 15 Jun 2010 04:06:00 GMT Indexed on 2010/06/15 4:32 UTC
Read the original article Hit count: 252

Filed under:

If your SharePoint site collection hasn't grown, but your content database has, the most likely culprit is versioning.  If a list -- or worse, a library -- has versioning enabled, the default is to keep every single one.  That means that every time someone edits and checks in a document, its storage footprint increases by the size of the document (and probably a little more).

The solution?  It could be a bit painful, but you'll need to go back into each library and restrict the number of versions to keep (three is sufficient for most uses, but your needs may vary).  I suggest keeping only major versions as well, since minor versions are really just stopping points on the way to a published document.

Of course if you have a real business need to keep all those versions around, then you'll want to look into an archiving solution that will take the old versions out of the content database but still make them available if necessary.

© ASP.net Weblogs or respective owner

Related posts about sharepoint