• ThomasRushton - Friday, March 2, 2018 6:01 AM

    If you follow the steps to create a scheduled task to cycle the error log every day, and then set SQL Server to retain only ten logs, then that'll give you your ten days of logs.

    Unfortunately, if you reboot the server, that'll also run sp_cycle_errorlog, so you might want to set the number of logs to 11.  <insert Spinal Tap reference here>

    When reboot the server the jobs cannot continue ? im need to setg to 10 again? why ?

    Thanks
    Almir