Retention period of Audit Logs

[Rochel hans]

We have a requirement to increase the audit period to 180 days and extract logs just around some tables and store them at some secure location on a monthly basis.

Kindly guide on how could we achieve this and what are the impacts we need to consider this could have on the system performance.

[Jeff Currier]

Your best bet may be to create a daily job to extract the data in which you are interested and write it to an external file or database.  This way the retention stays the same and you keep all the data you need.  You could break up the extraction into jobs by table to limit the load on the system as there can be a lot of data in the audit log

[JulJameson]

good advice it suited me better

[Rochel hans]

Thankyou for the response.