x

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

colibri gravatar image

colibri
151 15 15 15

(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

Grant Fritchey gravatar image

Grant Fritchey ♦♦
103k 19 21 74

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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x57
x8

asked: Sep 12, 2011 at 04:37 AM

Seen: 952 times

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