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?

more ▼

asked Sep 12, 2011 at 04:37 AM in Default

avatar image

151 15 15 17

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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).

more ▼

answered Sep 12, 2011 at 05:13 AM

avatar image

Grant Fritchey ♦♦
137k 20 43 81

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!

Sep 12, 2011 at 06:00 AM colibri

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?

Sep 12, 2011 at 07:12 AM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Sep 12, 2011 at 04:37 AM

Seen: 1164 times

Last Updated: Sep 12, 2011 at 04:37 AM

Copyright 2016 Redgate Software. Privacy Policy