Re: Setting up Trace in SQL

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 11/21/03 

Date: Fri, 21 Nov 2003 09:06:10 -0500

There is no way to append it that I know of. What benefit would this give
you? 

-- 
Andrew J. Kelly
SQL Server MVP
"Audrey L" <robwhitz@yahoo.com> wrote in message
news:07c601c3afe8$20a4ca90$a101280a@phx.gbl...
> 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.
>
> As the maxsize of the trace file is 5MB, I managed to
> configure it to perform a rollover whenever the threshold
> is reached.
>
> One thing that I would like to clarify is: - Suppose the
> trace file 'TraceA.trc' already exists in the directory.
> The DB was re-started.  New records are not appended to
> the trace file at all.  Is there a way to activate this?
> Or is there any workaround?
>
> Would appreciate advice.  Thanks ...

Relevant Pages
Loading