Systems Engineering and RDBMS

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:

err_log

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: