Yes it is possible to change the no. of Error logs retention. We can follow the below steps to change the Error log file retention.
1. Open SQL Server Management Studio and then connect to SQL Server Instance
2. InObject Explorer, ExpandManagement Node and then right click SQL Server Logs and click Configure as shown in the snippet below.
3. In Configure SQL Server Error Logs window you can enter the value between 6 and 99 for the number of error logs and click OK to save the changes
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment