How to delete Audit log

All replies

• 

  

  0

  Sign in to vote

  This might  be helpful. http://blogs.msdn.com/sowmyancs/archive/2008/05/29/create-a-tool-or-interface-to-delete-the-audit-log-from-content-db-of-an-auditing-enabled-sharepoint-site.aspx. Plase thank the original author. I ama using something similar to this.

  ---

  Signature

  Monday, September 1, 2008 8:43 AM
• 

  

  0

  Sign in to vote

  If you have the infrastructure update deployed then you can use the new trimauditlog stsadm command to delete old entries: http://technet.microsoft.com/en-us/library/cc706879.aspx

  • Proposed as answer by M. Hassan Raza Tuesday, August 10, 2010 11:50 AM

  Tuesday, September 2, 2008 12:55 AM
• 

  

  0

  Sign in to vote

  How long are audit logs kept by default?  I've searched all over, but I can't find anything.  Are they kept indefinitely?  

  Wednesday, September 10, 2008 6:48 PM
• 

  

  0

  Sign in to vote

  As far as I'm aware the data is retained indefinitely (thus the need for the new stsadm command).

  Thursday, September 11, 2008 3:18 AM
• 

  

  0

  Sign in to vote

  I suppose you mean the "Trace" log in Central Admin > Operations > Diagnostic Logging?
  
  In that case, there's an option where you can specify the nr. of log files and the nr. of minutes to use a log file
  
  Default= 96 Log files and 30 min. to use a log file

  And the default path for the logs are in "Hive 12"\Logs
  

  ---

  Daniel Bugday Web: http://www.sharepointforum.com/ Blog: http://www.sharepointforum.com/en-US/Blog/

  Thursday, September 11, 2008 8:48 AM
• 

  

  0

  Sign in to vote

  Gary- thanks for the info, that was my assumption also, further confirmed by new command. 
  
  
  Daniel- No, not the Trace log.  We're actually speaking of auditing at the site collection level.  Try these two links to familiarize yourself with it:
  
  http://office.microsoft.com/en-us/sharepointserver/HA100997261033.aspx?pid=CH101237681033
  
  http://office.microsoft.com/en-us/sharepointserver/HA101000051033.aspx
  
  Then re-read the questions and the link to read about the new STSADM command, TrimAuditLog.
  
  

  • Proposed as answer by M. Hassan Raza Tuesday, August 10, 2010 11:50 AM
  • Marked as answer by Mike Walsh FIN Wednesday, February 1, 2012 8:38 PM

  Thursday, September 11, 2008 2:22 PM
• 

  

  0

  Sign in to vote

  I know this is an older post, but I found it useful and wanted to contribute.  We had the same problem of on oversized AuditData table in the content database.  I wrote a powershell script to automate deleting the AuditData table records.  You can find the script here:

  http://surfpointtech.com/2012/02/01/sharepoint-auditdata-table-is-too-large-powershell-script-to-schedule-stsadm-o-trimauditlog/

  Wednesday, February 1, 2012 8:38 PM