• 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>

    Thomas Rushton
    blog: https://thelonedba.wordpress.com