Thursday, January 13, 2011

Truncate the AuditData table in SharePoint

The Auditdata table in my sharepoint site is becoming huge (over 70 Gb and 200 Million records) running the Trimauditlog command (http://technet.microsoft.com/en-us/library/cc706879.aspx) times out as it is very slow.

Can i simply truncate that table? or there are side effects to doing that (other than losing audit data)

  • (You didn't specify if you'd tried this approach already) Why not trim the table in smaller chunks up to your target date using the '-date' parameter instead of all at once?

    From vinny

0 comments:

Post a Comment