Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

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

  Date: Nov 01    Category: Sharepoint    Views: 1174

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



5 Answers Found

Answer #1    Answered On: Nov 01    

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: Nov 01    

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

Answer #3    Answered On: Nov 01    

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: Nov 01    

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

Answer #5    Answered On: Nov 01    


a good link might better explain