Working with Error Logs in SQL Server Management Studio
By: Haroon Ashraf
SQL Server maintains error logs which can be reviewed to troubleshoot some issues related to SQL Server. The SQL Server Error Logs, as the name indicates, contain errors that SQL Server encountered as a result of an activity or task which was run manually or in an automated way.
Normally it is the DBA or infrastructure team who investigates problems by looking through SQL Server Logs and finding the cause of a task failure, so that it can be fixed and prevented next time.
How to Access SQL Server Error Logs in SSMS
Error logs can be accessed under the Management node in SSMS and expanding the SQL Server Logs section. This includes a Current log which is the most recent information and also archived logs from pervious time periods. You can double click on one of the logs to see detailed information that has been collected.
- Simple way to find errors in SQL Server error log
- Reading the SQL Server log files using TSQL
- Stop logging all successful backups in your SQL Server error logs