Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

SharePoint 2007 - My content database growing overnight to 100+ gbs

  Date: Sep 24    Category: Sharepoint    Views: 697

I am running into deep trouble with the content database. The content database grows to 100+ gbs over night. However when I checked using the SharePoint Space Monitor tool, it shows the size of all the content is just 20+ gbs.

I have even stopped the indexing service.

My content database recovery mode is set to FULL and configured for database mirroring for DR.

Not sure what is causing the database growth. Any help in this regard is much appreciated.



4 Answers Found

Answer #1    Answered On: Sep 24    

I had this happen with my log files when I had versioning turned on and a workflow on the same list.

Answer #2    Answered On: Sep 24    

Thanks for the pointer .... But would it take 100 + GBs
Is there a way to reclaim the space from content database?

Answer #3    Answered On: Sep 24    

Check your audit table. Do you have auditing turned on anywhere in your sites? run the ststadm command to truncate the table. Do some analysis ahead of time and truncate chunks of days instead of all at once

Answer #4    Answered On: Sep 24    

Thanks for the pointer. That was a nice suggestion...
My auditdata table is storing almost 4 years of data and is taking 90 + GBs of data.