Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

How do I use sp_configure on SQL 2005 (full edition) to disable these 200MB mulithreaded traces that are going on in the background and filling up my hard drive?

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\audittrace_20061029095619_4.trc


Thanks for the answer. Here was the fix:

c:\> osql -E
> sp_configure 'show advanced options', 1
> go
> RECONFIGURE
> go
> sp_configure 'c2 audit mode', 0
> go
> RECONFIGURE
> go
Then restart SQL server.
share|improve this question

1 Answer 1

up vote 1 down vote accepted

Have a read of Enabling and Disabling C2 Auditing.

However before you do turn this off, hadn't you better check as to why they are on in the first place? Do you have a business requirement for C2 Audit Traces to be turned on?

If you do have a requirement to keep them, you could write a script to move them every so often to a suitable secure location. By default they are written to the default data directory selected on install. If this is a problem you may be able to change the location of the default data directory but will probably require bouncing the services for it to take affect.

To change the default database file location, open SQL Server Management Studio and right click the Server object, select Properties and then Database Settings.

share|improve this answer
    
this was on a DEV system. didn't need it to be on and i dont know how it got "on". –  djangofan Feb 25 '10 at 17:16
    
i guess the problem may be that im using a full version of sql instead of the DEV version for development... –  djangofan Feb 25 '10 at 17:17
    
Dev edition is the same as the "full version" sql server enterprise. Only the licensing is different –  Jim B Feb 25 '10 at 17:35

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.