Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

This is precaution question :)


When I was configuring SQL Server 2008 R2 database engine, I checked "Enable C2 audits" which I don't really need. From that time it created a lot of files like audittrace20130918235148.trc. I disabled C2 auditing in SQL Server Management Studio by unchecking checkbox.


Are those files really from C2 audit? If so, can I safely remove them without worring about data stored in databases? Again: I do not need audit logs.

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

Are those files really from C2 audit?

The audit file format is audittraceyyyymmddHHMMSS.trc

After you disable C2 audit using

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

and you are absolutely sure that you dont need the audit files, you can delete the files.

If so, can I safely remove them without worring about data stored in databases?

The C2 Audit Mode uses SQL Trace to capture audit events, which are stored in trace files i.e. they are not stored in database, unless you have a job that loads the files into a database.

Note : The C2 security standard has been superseded by Common Criteria Certification.

share|improve this answer
    
Thank you very much Sir, I did as you said and everything seams to be fine! –  Saelic Vogel Sep 24 '13 at 9:39
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.