I configure SQL Audit for my SQL. Even though I set the Max rollover files to 500, but the SQL Audit do not over write the old records. What should I do? Please help. Thank you
From my previous experience, I remember. When it reaches the max limit, it will delete the oldest file and create a new file.
If you check the files on disk, you must have something created with latest date.
If you need to retain audit files, suggest you regularly archive them, moving to another folder or disk. They also compress very well, so a ZIP archive is also a good choice.
IIRC correctly, audit will never delete files if they hit the rollover limit, it will generate an error that the audit can't run.
I got errors when they hit the rollover limit. Audit stops running