Post reply

Error Log

  • August 27, 2009 at 8:44 am

    #135080

    What kicks off sql server to create a new error log? I am troubleshooting an issue that started on 8/5/09, which so happens to be the same day a new error log started. Any help will be greatly appreciated.

  • August 27, 2009 at 8:52 am

    #1045600

    A restart of the service or the execution of sp_cycle_errorlog. Easy to tell which, check the beginning of the error log, if the SQL startup messages are there then it's as a result of a service restart. I think that sp_cycle_errorlog adds a message to the old and new log saying that the log was cycled.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 27, 2009 at 9:29 am

    #1045633

    Thank you. I appreciate the help.

Viewing 3 posts - 1 through 2 (of 2 total)

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