Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am in a new shop and the below error started to show up on 2/22 repeatedly until 3/7.

Event Type: Error
Event Source:   SQLSERVERAGENT
Event Category: Alert Engine 
Event ID:   318
Description:
Unable to read local eventlog (reason: The event log file is corrupted).

Event Type: Information
Event Source:   SQLSERVERAGENT
Event Category: Alert Engine 
Event ID:   311
Date:       2/22/2011
Time:       6:52:44 AM
User:       N/A
Computer:   XXXXXXX
Description:
Attempting to re-open the local eventlog...

Event Type: Warning
Event Source:   SQLSERVERAGENT
Event Category: Alert Engine 
Event ID:   312
Description:
Successfully re-opened the local eventlog - NOTE: Some events may have been missed.

Then, the server shut down unexpectedly. The shutdown stopped the events. But, my concerns are: What was happening? Does anyone know what this means? More importantly, what kind of measures do we need to take to prevent this from happening?

share|improve this question
    
what version of SQL, and what is the O/S? –  SQLRockstar Mar 10 '11 at 0:52
add comment

2 Answers

up vote 5 down vote accepted

Sounds like you've got some sort of corruption problem on the disk which the SQL Agent logs get written to. I'd check the disk for corruption, as well as the C drive in case it's talking about the application log which the SQL Agent also writes to.

share|improve this answer
add comment

Could be nothing important according to KB 811484

However, I'd schedule a chkdsk on that drive on next boot, and makre sure all my backups are in order.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.