Post reply

Errorlogs removing

  • June 22, 2009 at 8:58 am

    #205773

    Can one delete old errorlogs i.e. ERRORLOG.1. ERRORLOG.2 etc. or does one need to run a process to purge them?

  • June 22, 2009 at 9:11 am

    #1013370

    No need to delete them. SQL only keeps a certain number (default 6) and automatically deletes the older ones. New error logs get created (and older ones deleted) whenever SQL is restarted or the error log is cycled. (sp_cycle_errorlog I think)

    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

  • June 22, 2009 at 9:26 am

    #1013391

    You want to keep a few around. When there are issues, it's possible someone will reboot 2-3 or more times and you don't want to have those logs gone. 6 is probably more than you need, but better to have 1-2 more than you need than not have them.

    I have seen people that recycle them weekly so they don't get too large, but in that case I'd say you want to keep more like 10 around.

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

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