Is it OK to truncate AuditBase table? RRS feed

  • Question

  • Hi all,

    I've got an issue where audit was turned on in CRM 2011 for a production environment.  After a few months time, the auditbase table has now got nearly 10 million records and is consuming heaps of disk space. I tried to delete the audit log using audit log managemnt ui tool but that simply failed as every single partition has over 2 million records and the delete action just fills the sql log disk.

    I am looking at quick ways to clean up audit table, we don't really need the data in audit table any more. Is it save just to truncate auditbase table, I know this is not recommended but what are the implications of doing so? I tried in a test envionment it simply does the work in seconds...


    Monday, March 10, 2014 9:46 PM

All replies