Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

SharePoint Audit Table in content database (dbo.AuditData)

  Asked By: Marques    Date: Jun 25    Category: Sharepoint    Views: 9849

We have a heavy used site that has all auditing enabled (Site Actions,
Site Settings, Modify All Site Settings, Site Collection Audit Settings,
All items checked under Events to audit)

This has caused the table dbo.AuditData in our WSS_WebApp_Content1
database to become very large. Currently is has 135,614,755 records and
is 33.8 GB in size!

Here are my main questions:

- Is there any risk to moving this data out of this table into
an archival database?

- If we uncheck events to audit, will it automatically remove
the space?

- Is there a way to automatically clear it after X days
(without writing SQL jobs)?

- How does this affect performance?

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Kristian Chaney     Answered On: Jun 25

I have figured this one out. There are two methods to deal with this
table.

First, MS has released an stsadm command (stsadm -o trimauditlog) as
part of the infastructure update that will allow you to manage this
data. Click here to see the details on it.
technet.microsoft.com/en-us/library/cc706879.aspx

Second, since our company is not ready implent this update. I am
going to crack it open with powershell. Something like this:

$SiteCollection = Get-SPsite
$SiteCollection.Audit.DeleteEntries(DateTime.Now.ToLocalTime().AddDays
(1))
$SiteCollection.Audit.Update()

For more info on powershell and sharepoint  objects, check out this
blog - http://sharepoint.microsoft.com/blogs/zach

 
Answer #2    Answered By: Alicia Scott     Answered On: Jun 25

I did not know that (stsadm.exe -o trimauditlog) was part of the
infrastructure update.

I'll make sure to add it to the course content.

 
Didn't find what you were looking for? Find more on SharePoint Audit Table in content database (dbo.AuditData) Or get search suggestion and latest updates.




Tagged: