Managing trace files on Sql Server 2005
Posted
by Sophtware
on Stack Overflow
See other posts from Stack Overflow
or by Sophtware
Published on 2010-05-18T19:15:16Z
Indexed on
2010/05/18
19:20 UTC
Read the original article
Hit count: 190
I need to manage the trace files for a database on Sql Server 2005 Express Edition. The C2 audit logging is turned on for the database, and the files that it's creating are eating up a lot of space.
Can this be done from within Sql Server, or do I need to write a service to monitor these files and take the appropriate actions?
I found the [master].[sys].[trace] table with the trace file properties. Does anyone know the meaning of the fields in this table?
© Stack Overflow or respective owner