We'd enabled all types of audit events for our production web-application and ended up with an issue with DB as auditData table grown to 50GB. Now, we want to reduce the size of the AuditData table.
We already executed stsadm -o trimauditlog and it just helped us to reduce 5GB however stil would like to reduce the size of the table, so thought of deleting all "opening or downloading..." event type entries (now, we disabled the same event). Please let me the best possible way for the same.
also, have you ever faced an issue with DB instance due the size of a table, if so, how did you resolve the issue?