SQL Server 2000 logo

Increasing the number of SQL Server Error Logs

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
-> Continue reading Increasing the number of SQL Server Error Logs