Could some one let me know why the following error is happening and resolution for this. This problem exists in SQL Server 2005 which has specific hotfix. But we are currently using SQL Server 2008. Following are the error details,
LogName : Application
Source : SQLSERVERAGENT
Event ID : 318
Level : Error
Task Category : Alert Engine
Message : Unable to read local eventlog (reason: The event log file has changed between read operations).
Note: Immediately after this error there is a Warning message saying "Successfully re-opened the local eventlog - NOTE: Some events may have been missed."
We didn't face this problem before but suddenly we are seeing this issue quite often on some of our SQL Instances.
View Complete Post