DBAs - Do you know all the log files?

SQL Server stores vital error and performance information in several different logs. You should be aware of all of them:

1. SQL Server Error Logs

   • Configure how many you want to keep
   • You should Back up your SQL Server error logs with your other scripts
   • Sp_cycle_errorlog

2. SQL Server Agent Error Log

   • Recycles after every service restart

3. Job History Logs

   • Agent properties, Job System tab
   • Probably too low by default
4. DBMaint history logs
5. (Event Viewer) - Issues