Re: SQL Code for Archiving Server Event Logs

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Malcolm Cook (mec_at_stowers-institute.org)
Date: 11/08/04 

Date: Mon, 8 Nov 2004 11:11:01 -0600

http://www.logparser.com/

will allow you to populate SQL tables with system event log

"Phill Heath" <PhillHeath@discussions.microsoft.com> wrote in message
news:D8FF4CDA-4611-4675-A649-9B0AD1686550@microsoft.com...
> Thanks but I actually want to archive the windows server event logs like:
>
> application log
> Security Log
> DNS Log
> etc etc
>
> any Ideas?
>
> Phill
>
>
> "Mike Epprecht (SQL MVP)" wrote:
>
> > Hi
> >
> > SQL Server event logs are a text file in the installed Data Directory
under
> > Logs.
> > Read them off disk and there you go.
> >
> > Regards
> > Mike
> >
> > "Phill Heath" wrote:
> >
> > > Hi
> > >
> > > I would like to create a stored proc which will get a specified
servers
> > > event logs export them to text files and clear the log. I already
have a
> > > cursor which will read the server details from a table but don't know
how to
> > > export the logs or even if thats possible.
> > >
> > > Thanks
> > >
> > > Phill

Relevant Pages

  • Re: Exchange Global List
    ... SP1 installed and no errors in either the client or server event logs. ... "Lanwench [MVP - Exchange]" ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 and Fax to email problem
    ... Anything in server event logs, try a scan and look in the event logs ... one mailbox! ... I'm quite confident the problem isn't with the fax but somehow messages ...
    (microsoft.public.windows.server.sbs)
  • Re: Exchange Global List
    ... > SP1 installed and no errors in either the client or server event logs. ... Then check John's reply w/r/t cached mode. ...
    (microsoft.public.windows.server.sbs)