Thursday, February 10, 2011

SQL Server 2008 Tools - Log File Viewer

The log File Viewer is launched from within SQL Server Management Studio. To open it , follow these steps.
  1. Expand the Management node in Object Explorer.
  2. Expand SQL Server Logs.
  3. Right-click on a log and select "View SQL Server Log."












One of the benefits of the Log File Viewer is that it allows consolidation of practically all the logs the DBAs are most interested in. SQL Server logs, SQL Agent logs, and Operating System logs can be opened
in the same window for easy correlation of system and SQL Server events.


Posted by at

2 comments:

Subscribe to: Post Comments (Atom)