SQL 2008 Trace Logs - Change Retention and File Size

I have a single SQL 2008 Standard Server. A lot of Auditrace files are being created. There is currently no retention policy and the files role over at 5MB.

How would I change the retention policy for my audittrace files?
LVL 1
First LastAsked:
Who is Participating?
 
Eugene ZCommented:
are you sure they are audit?
if 'yes'  and you do not need them

you can disable C2 audit using this code:

EXEC sp_configure 'c2 audit mode', 0
go
reconfigure with override

--
see more
c2 audit mode Option
http://technet.microsoft.com/en-us/library/ms187634(v=sql.105).aspx

The C2 Audit trace for SQL server 2005 and SQL 2008 R2
http://www.experts-exchange.com/Database/MS-SQL-Server/Q_28071655.html
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
I don't think there's a retention policy for the files. You need to clean it manually or write a script and schedule it to do it automatically.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.