Working with Error Logs in SQL Server Management Studio


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.

SQL Server Logs containing Error Logs
Related Information

Comments For This Article

get free sql tips
agree to terms