question

colibri avatar image
colibri asked

twelve hour gap in my error logs

There is a 12 hour gap in my error logs where no information is reported and it occurs right before a server crashed. Is there another way to get information on what caused this crash... a reason why SQL Server stopped reporting information udirng this time?
errorlogs
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Grant Fritchey avatar image
Grant Fritchey answered
It sounds like, possibly, the problem was 12 hours in the past and the crash just resolved it? How about errors in the OS error logs? There are only a few places to get errors from and it sounds like your error did something to the log. That or someone edited the log during/after the crash (the log is just a text file).
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Two instances... one fails, the other does not, you lose the log on the one that failed... Any chance the logs are writing on top of each other?
1 Like 1 ·
That's the mystery here.... we had this happen twice over the weekend so no one was here the second time it happened. The OS error logs has activity but does not show any errors that indicate an issue with SQL Server. We would normally assume this is a issue with the box (not enough RAM, etc) but there is another instance on this box that was unaffected and did not lock up. So it is isolated to one instance. It's been a challenge to troubleshoot this one any suggestions would be great!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.