Solved

SQL 2008 Trace Logs - Change Retention and File Size

Posted on 2015-01-07
2
236 Views
Last Modified: 2015-01-13
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
Comment
Question by:First Last
2 Comments
 
LVL 47

Expert Comment

by:Vitor Montalvão
ID: 40537884
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
 
LVL 42

Accepted Solution

by:
EugeneZ earned 500 total points
ID: 40539278
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

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now