Out of Control Audit Logs
Our content DB has grown very large relative to its content, the culprit turns out to be the Audittable, I have ran the stsadm trimauditlog commmand and it ran without error but it didnt make any difference in the size of the content DB. Is there something that has to be done after this?
June 5th, 2010 7:21pm

Hi themush, It sounds as though you need to shrink the content database after running the TrimAuditLog STSADM command as detailed in this post: http://blogs.msdn.com/b/subhajitc/archive/2009/05/20/tip-the-untold-story-of-audit-logs-in-sharepoint.aspx. This involves using the DBCC SHRINKDATABASE Transact-SQL command. Note that as far as I know, Microsoft do not recommend shrinking any SharePoint database except content databases. Also note that it's a very performance intensive operation so I would suggest you do this outside of peak hours. The MS White Paper is available at http://office.microsoft.com/download/afile.aspx?AssetID=AM102632301033 (it's a Word document). Another decision to consider (if you haven't already) is using the simple DB recovery model instead of full - this reduces content DB size considerably at the expense of DB log file backups. More information available at http://msdn.microsoft.com/en-us/library/ms191164.aspx. Obviously this is only appropriate where point in time backups are not required. Finally, I would also take a look at what level of auditing you have enabled - John Timney wrote a good post over at http://www.johntimney.com/blog/Controlling+MOSS+Audit+Log+Sizes.aspx that describes the performance issues related to enabling item level auditing. HTH. Benjamin Athawes - Twitter: @benjaminathawes - Blog: http://mossblogger.blogspot.com - Mail: mail at bathawes.com
Free Windows Admin Tool Kit Click here and download it now
June 6th, 2010 1:41pm

Are the options you can choose thru site administration considered item level auditing?
June 7th, 2010 4:41pm

Site Settings > Configure Audit Settings AFAIK, anything within "Documents and Items" should be considered as item level auditing, as opposed to auditing lists, libraries and sites. Basically, I suggest you review each of these items and decide whether they really need to be audited with a view to reducing the size of your content DB going forward. For example, recording document deletion may be important to your organisation, but auditing document views may not be. Benjamin Athawes - Twitter: @benjaminathawes - Blog: http://mossblogger.blogspot.com - Mail: mail at bathawes.com
Free Windows Admin Tool Kit Click here and download it now
June 7th, 2010 8:57pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics