Large Gaps in Error Log

  • csoloway

    Ten Centuries

    Points: 1027

    I recently was involved in a situation on a large database where the error log was simply not logging for over a week. In the past I've seen that behavior with resource issues. There were not trace flags in place that would have turned off logging for over a week. Any ideas on where to look to determine why this occurred?

  • Jo Pattyn

    SSC-Dedicated

    Points: 31399

    Windows logs?

  • csoloway

    Ten Centuries

    Points: 1027

    No the SQL Server Error Logs. Skipped a week before it started logging again.

  • Jo Pattyn

    SSC-Dedicated

    Points: 31399

    I meant, perhaps the windows logs (eventvwr) mentions why it couldn't write to the error logs.

  • csoloway

    Ten Centuries

    Points: 1027

    No, not any indications why it couldn't write.

  • Kenny Jozi

    SSCrazy

    Points: 2004

    " Any ideas on where to look to determine why this occurred? "

    Jo Pattyn already answered the first place to look at is Windows Eventviewer.

    SQL 2000/2005/2008/2012 DBA - MCTS/MCITP

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply