Post reply

Error Log Updates

  • December 7, 2008 at 9:46 am

    #71687

    On One server error log reintializing, on daily basis,means it is creating new errorlog, instead of continue the errorlog.(errorlog1,eroorlog2.....).

    How can i fix this problem.

    Please any one suggest me.

    Warm Regards,

    Upender Perla

  • December 7, 2008 at 10:13 am

    #908940

    Means either the SQL service is restarting every night, or there's a job that's cycling the error log (sp_cycleerrorlog)

    Check the beginning of the new error log, either you'll see SQL's startup messages or an entry saying the log was cycled. That'll tell you what happened.

    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

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

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