Re: Setting up Trace in SQL

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

Date: Sat, 22 Nov 2003 09:18:11 -0500

Although I don't usually set up traces to start when the db restarts I don't
know why the presence of an existing file would be an issue. How exactly
are you starting the trace? Can you simply specify a name for the file
that would be unique each time it runs? 

-- 
Andrew J. Kelly
SQL Server MVP
<anonymous@discussions.microsoft.com> wrote in message
news:057a01c3b0ba$16ffbbd0$a401280a@phx.gbl...
> I agree.  But supposed if I were to re-start the DB, the
> audit does not kick off at all coz the trace files still
> exist in the system.
>
> In that case, I would need to move the trace files out
> from the designated directory.  Where and how can I do
> this?  Ot typically, how does the other DBA achieve this?
>
> >-----Original Message-----
> >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

  • Re: Best Practices for Auditing
    ... > question to you all is, since we want to also audit the ... > trace, removing records from the trace, etc.) ... SQL Server there is no way to stop members of the System ... auditing data, for example if you use a sproc to return ...
    (microsoft.public.sqlserver.security)
  • Re: One Web Service updates SQL, another cant?
    ... section of the Trace Properties dialog. ... And then I start getting the database closed errors on subsequent calls. ... > The error suggests that somehow the connection to SQL Server is being ... Could we have a look at your connection string? ...
    (microsoft.public.sqlserver.security)
  • RE: cannot delete a record in sql server 2005 through asp program
    ... Using trace script he provided and trace file created by the script. ... SQL Server database by the asp application. ... Microsoft Online Community Support ... a Microsoft Support Engineer within 2 business day is acceptable. ...
    (microsoft.public.sqlserver.programming)
  • Re: Profiler Security
    ... There's no way to restrict what a user of trace can see - if they ... etc. coming into SQL Server. ... >> want to assign the developers the sys admin sql role. ...
    (microsoft.public.sqlserver.security)
  • Re: Auditing sql server at runtime
    ... SQL Server native tools don't do any port sniffing. ... Use SQL Profiler to define your trace, ... Create a SQL Agent job to run that trace, paste the script into it. ...
    (microsoft.public.sqlserver.clients)