Interview Questions

1. Is it possible to increase the retention of Error log files and How?

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. In Object Explorer, Expand Management 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
By Expert User 2 0
Is this helpful? Yes No

Submit an interview question

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


Leave a Comment

Check out more interview questions

Based on your skills

MS SQL Server

1137750 1719 15 859


27898 92 0 46


22555 72 1 36