View the SQL Server Error Log (SQL Server Management Studio)

 

Updated: July 29, 2016

Applies To: SQL Server 2016

The SQL Server error log contains user-defined events and certain system events you will want for troubleshooting.

  1. In SSMS, select Object Explorer

To open Object Explorer: Keyboard shortcuy is F8. Or, on the top menu, click View/Object Explorer Object_explorer

  1. In Object Explorer, connect to an instance of the SQL Server and then expand that instance.

  2. Find and expand the Management section (Assuming you have permissions to see it).

  3. Right-click on SQL Server Logs, select View, and choose View SQL Server Log. View_SQLServer_Log_SSMS

  4. The Log File Viewer will appear (It might take a minute) with a list of logs for you to view.

  5. Several people have recommended MSSQLTips.com's helpful post Identify location of the SQL Server Error Log file. They have a lot of terrific information - be sure to check them out!

Community Additions

ADD
Show: