| Author |
Unable to read local eventlog
|
|
| Brian Drab 2002-11-10, 10:23 am |
| I have searched Technet and also globally with other websites but have not
found an answer.
When I reboot my machine with SQL Server 2000 SP2 (8.00.679) the Windows
2000 SP3 Application Event Log shows the following error:
Event Type: Error
Event Source: SQLSERVERAGENT
Event Category: Alert Engine
Event ID: 318
Date: 11/10/2002
Time: 10:08:38 AM
User: N/A
Computer: DRABSERVER
Description:
Unable to read local eventlog (reason: The event log file has changed
between read operations).
The very next event logged is:
Event Type: Information
Event Source: SQLSERVERAGENT
Event Category: Alert Engine
Event ID: 311
Date: 11/10/2002
Time: 10:08:38 AM
User: N/A
Computer: DRABSERVER
Description:
Attempting to to re-open the local eventlog...
and the next:
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Alert Engine
Event ID: 312
Date: 11/10/2002
Time: 10:08:38 AM
User: N/A
Computer: DRABSERVER
Description:
Successfully re-opened the local eventlog - NOTE: Some events may have been
missed.
So it appears that it simply is recording that it tried to read the event
log before it was ready. Is there any way to avoid this so that an error is
not recorded??? By changing service dependencies or something?
Thank you very much!!!
| |
| Andrew J. Kelly 2002-11-10, 2:23 pm |
| This happens when SQL Server attempts to write to the NT Event log and it
has been purged since the last time it opened it. This will happen if you
go tot he NT Event Log viewer and tell it to clear the log. This is nothing
to be worried about at all.
--
Andrew J. Kelly, SQL Server MVP
TargitInteractive
"Brian Drab" <briandrab@adelphia.net> wrote in message
news:Navz9.12355$6g.4229813@news1.news.adelphia.net...
> I have searched Technet and also globally with other websites but have not
> found an answer.
>
> When I reboot my machine with SQL Server 2000 SP2 (8.00.679) the Windows
> 2000 SP3 Application Event Log shows the following error:
> Event Type: Error
> Event Source: SQLSERVERAGENT
> Event Category: Alert Engine
> Event ID: 318
> Date: 11/10/2002
> Time: 10:08:38 AM
> User: N/A
> Computer: DRABSERVER
> Description:
> Unable to read local eventlog (reason: The event log file has changed
> between read operations).
>
> The very next event logged is:
> Event Type: Information
> Event Source: SQLSERVERAGENT
> Event Category: Alert Engine
> Event ID: 311
> Date: 11/10/2002
> Time: 10:08:38 AM
> User: N/A
> Computer: DRABSERVER
> Description:
> Attempting to to re-open the local eventlog...
>
> and the next:
>
> Event Type: Warning
> Event Source: SQLSERVERAGENT
> Event Category: Alert Engine
> Event ID: 312
> Date: 11/10/2002
> Time: 10:08:38 AM
> User: N/A
> Computer: DRABSERVER
> Description:
> Successfully re-opened the local eventlog - NOTE: Some events may have
been
> missed.
>
> So it appears that it simply is recording that it tried to read the event
> log before it was ready. Is there any way to avoid this so that an error
is
> not recorded??? By changing service dependencies or something?
>
> Thank you very much!!!
>
>
| |
| Brian Drab 2002-11-10, 2:23 pm |
| Thank you!!!
"Andrew J. Kelly" <akelly@targitinteractive.com> wrote in message
news:OhyXR9OiCHA.2636@tkmsftngp08...
> This happens when SQL Server attempts to write to the NT Event log and it
> has been purged since the last time it opened it. This will happen if you
> go tot he NT Event Log viewer and tell it to clear the log. This is
nothing
> to be worried about at all.
>
> --
> Andrew J. Kelly, SQL Server MVP
> TargitInteractive
>
>
> "Brian Drab" <briandrab@adelphia.net> wrote in message
> news:Navz9.12355$6g.4229813@news1.news.adelphia.net...
> > I have searched Technet and also globally with other websites but have
not
> > found an answer.
> >
> > When I reboot my machine with SQL Server 2000 SP2 (8.00.679) the Windows
> > 2000 SP3 Application Event Log shows the following error:
> > Event Type: Error
> > Event Source: SQLSERVERAGENT
> > Event Category: Alert Engine
> > Event ID: 318
> > Date: 11/10/2002
> > Time: 10:08:38 AM
> > User: N/A
> > Computer: DRABSERVER
> > Description:
> > Unable to read local eventlog (reason: The event log file has changed
> > between read operations).
> >
> > The very next event logged is:
> > Event Type: Information
> > Event Source: SQLSERVERAGENT
> > Event Category: Alert Engine
> > Event ID: 311
> > Date: 11/10/2002
> > Time: 10:08:38 AM
> > User: N/A
> > Computer: DRABSERVER
> > Description:
> > Attempting to to re-open the local eventlog...
> >
> > and the next:
> >
> > Event Type: Warning
> > Event Source: SQLSERVERAGENT
> > Event Category: Alert Engine
> > Event ID: 312
> > Date: 11/10/2002
> > Time: 10:08:38 AM
> > User: N/A
> > Computer: DRABSERVER
> > Description:
> > Successfully re-opened the local eventlog - NOTE: Some events may have
> been
> > missed.
> >
> > So it appears that it simply is recording that it tried to read the
event
> > log before it was ready. Is there any way to avoid this so that an error
> is
> > not recorded??? By changing service dependencies or something?
> >
> > Thank you very much!!!
> >
> >
>
>
|
|
|
|