Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 269
  • Last Modified:

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?
0
First Last
Asked:
First Last
1 Solution
 
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
 
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
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.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now