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