Error log configuration

The default retention for SQL Server error logs is 6. This may cause issues if there are a number of SQL Server restarts, you could lose the log with the error in it that you need to investigate.

I always try to increase that retention from 6 to at least 16 (SSMS -> Management -> SQL Server Logs -> Configure). Change the maximum number of error logs - maximum of 99.

Try to keep the size of these logs manageable by regular cycling of the logs.

We do this by executing the stored procedure cycle errorlog and include this as a step in our weekly maintenance.

This way each log is for a week and we should retain the last 16 weeks