Hi,
I have configured SQL Server to activate a trace at every server startup. The main objective is to audit all critical events on the DB.
One thing that I would like to clarify is: - Suppose the trace file 'TraceA.trc' already exists in the directory. When the DB is re-started, new events are not appended nor does it overwrite the trace files. Is there a way to activate this? Or is there any workaround?
Would appreciate advice. Thanks ...
I have configured SQL Server to activate a trace at every server startup. The main objective is to audit all critical events on the DB.
One thing that I would like to clarify is: - Suppose the trace file 'TraceA.trc' already exists in the directory. When the DB is re-started, new events are not appended nor does it overwrite the trace files. Is there a way to activate this? Or is there any workaround?
Would appreciate advice. Thanks ...