Consolidating Error Logs from multiple SQL Servers using SSIS

SQL Server stores all informational messages, warning messages, and errors in operating system and application log files. As a database administrator (DBA), it is our responsibility to review the information in the error log files on a daily basis for any errors that have occurred in our SQL Server environment. However, manually reviewing the log files daily is not an easy task in a busy SQL Server environment, and it can quickly consume a large part of your day. Therefore, most DBAs tend to skip this when they are busy with other production problems.

Check out my article here, in which I showed how we can consolidate error log entries from multiple servers into a central location, and then report on them from central location.

This tip is published on MSSQLTips.com.

Advertisements