Increasing the number of SQL Server Error Logs

SQL Server 2000 logo

Via Tim Radney, here’s a quick and easy way to increase the number of error logs from the default of six.

The blog post also has a walkthrough in SQL Server Management Studio if you prefer using the GUI.

Using TSQL you can execute the following statement to increase to 99 files, simply change 99 to how ever many files you would like to retain.

Photo by Brandi Redd on Unsplash.

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: