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

Comments

Leave a Comment


Check out more interview questions

Based on your skills

MS SQL Server

97985 1720 4 860

Angular

2791 92 0 46

Wordpress

2158 72 0 36
AD Ad-Free