Log File Viewer
Log File Viewer in SQL Server Management Studio is used to access information about errors and events that are captured in log files.
You can view SQL Server log files from a local or remote instance of SQL Server when the target instance is offline or cannot start. You can access the offline log files from Registered Servers, or programmatically through WMI and WQL (WMI Query Language) queries. For more information, see View Offline Log Files. Following are the types of log files you can access using Log File Viewer:
Remote Maintenance Plans
SQL Server Agent
Windows NT (These are Windows events that can also be accessed from Event Viewer.)
Describes how to open Log File Viewer depending on the information that you want to view.
Describes how to view offline log files through registered servers and how to verify WMI permissions.
Provides Log File Viewer F1 Help.