How to delete old records in Audit database?
We have a requirement to remove old data in our auditing database as the audit database schema has reached 85 % of capacity. What criterion has to be kept in mind to perform this activity.
As there are couple of tables what should be our consideration. Should the data to be deleted be in sync with the time stamp? Is it advisable to remove data only from a particular table?
Need your inputs.