SQL Server- Identify location of the SQL Server Error Log file

SQL Server- Identify location of the SQL Server Error Log file The SQL Server Error Log file is per SQL Server instance. A DBA can identify the location of the SQL Server Error Log file used by an instance of SQL Server easily. DBA can identify SQL Server Error Log file used by SQL Server…

Recycling SQL Error Log and increasing max number of Error logs Stored

Recycling Error log is another important thing in case if you are storing login auditing with login success to Error log. With Recycling error log to avoid losing important data one should increase the number of Error logs stored. For Example: If Error log is growing at a rapid level then it can be recycled…