August 5, 2010 at 12:26 am
If audit file size saved on local server keeps growing in size, how to delete outdated file. For ex. I need audit file to have 2 months information and delete the information later than 2 months.Any help on this?
August 5, 2010 at 5:54 am
You may use the "MAX_ROLLOVER_FILES" option while creating the audit. If it is set to UNLIMITED then the files will not be rolled over.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 6, 2010 at 3:12 am
Well in this I can allow my audit file to grow in size. If I wanted to delete last month audit info. alone and continue with current month. How is this possible.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply