Changing the number of error logs for your instance
Posted by decipherinfosys on February 11, 2009
By default, 7 error logs are configured in SQL Server – one is active and there are 6 archived ones. What this means is that recycling takes place once the configured number is reached. Having 6 as the maximum number of archived log files is usually enough for the development, testing and benchmark environments, however in a production environment you would generally want to have a higher number configured so that in the event of an issue, you do not end up missing critical information that can help you to resolve the issue. So, how can you go about changing it?
Open up SSMS, then Management under that instance, SQL Server Logs, right click and select configure and you will get the option to re-set the number to be anything between 6 and 99. We typically set it to 15 in our production environments: