Archiving Change Tracking Log

Hi, is there are way to keep change tracking log indefinitely? The compliance for one of our AR customer requires that "Changes done to a security group" needs to be logged and kept indefinitely. Did some read thru and found the below:

  • Change Tracking Log configuration is global setting, once set, all Logs would follow the same which means this would take up a lot of SQL storage on a long term. 
  • From another thread, noticed that Management History DB is not meant to be huge and it might get corrupted

Any ideas how we can address this? I'm thinking of below options:

  • Write some SQL statements to offload from Management DB and run it as a schedule task? 
  • Read another thread, perhaps can consider exporting Archive Roles event logs? 

Thanks! 

Parents Reply Children
No Data