Overview
SQL Server maintains error logs, which can be reviewed to troubleshoot 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 that was run manually or in an automated way.
Normally, it is the DBA or infrastructure team who investigates problems by reviewing SQL Server Logs and finding the cause of a task failure, so that it can be fixed and prevented next time.
Explanation
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 previous time periods. You can double-click on one of the logs to see detailed information that has been collected.
Additional Information
- 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
Haroon Ashraf’s deep interest in logic and reasoning at an early age of his academic career paved his path to become a data professional.
He holds BSc (Gold Medal) and MSc Degrees in Computer Science and also received the OPF merit award.
His programming career began in 2006 working on his first data venture to migrate and rewrite a public sector database driven examination system from IBM AS400 (DB2) to SQL Server 2000 using VB 6.0 and Classic ASP along with developing reports and archiving many years of data.
His work and interest revolves around Business Intelligence and Database Centric Architectures and his expertise include database and reports design, development, testing, implementation and migration.
He has recently earned “Knowledge Management and Big Data in Business” certificate from The Polytechnic University of Hong Kong.
- MSSQLTips Awards: Trendsetter (25+ tips) – 2020 | Author of the Year Contender – 2018-2020
