How To Increase SQL Server Error Log File Count

 

For more information about SQL Server Error Log, you should type Error Log in our search section. SQL Server Error Log consists of 6 files by default. To increase this number, we first click Configure by right-clicking SQL Server Error Logs under Management as follows.

 

Click on “limit the number of error log files before they are recycled”to increase the Maximum number of error log as much as we want. As you can see from below, we can increase up to 99.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *