Identify and Correct a Large SQL Server Error Log

Learn how to find and remove a large SQL Server Error Log file when it consumes a lot of space on your drive

Simple way to find errors in SQL Server error log

In this tip we look at how to parse the SQL Server error log to only extract the errors and corresponding error messages.

Who can recycle the error log?

Cycling the error log

Search multiple SQL Server Error Logs at the same time

The code in this tip will show how to use two system stored procedures to identify all iterations of a given string in the available SQL Server error logs since a specific point in time.

Automate SQL Server Log Monitoring

Let SQL do the work and monitor your SQL Error Log files.

Identify location of the SQL Server Error Log file

How do I find out where the SQL Server Error Log file is located for a specific SQL Server instance? In this tip we look at different ways a DBA can identify the location of the SQL Server Error Log file used by an instance of SQL Server.