Page 47 - DCAP508_DATABASE_ADMINISTRATION

Unit 3: SQL Server Tools

3.2.1 Opening Log File Viewer Notes

How to Open Log File Viewer.

Did u know? You can open Log File Viewer in several ways, depending on the information
that you want to view.
To view logs that are related to general SQL Server activity
1. In Object Explorer, expand Management.
2. Do either of the following:
i. Right-click SQL Server Logs, point to View, and then click either SQL Server Log or
SQL Server and Windows Log.
ii. Expand SQL Server Logs, right-click any log file, and then click View SQL Server
Log. You can also double-click any log file.
The logs include Database Mail, SQL Server, SQL Server Agent, and Windows NT.
To view logs that are related to jobs

To view job history, in Object Explorer, expand SQL Server Agent, right-click Jobs, and
then click View History.
The logs include Database Mail, Job History, and SQL Server Agent.

Another way to view the SQL Server Agent log is to expand SQL Server Agent, expand
Error Logs, right-click a log file, and then click View Agent Log.
The logs include Database Mail, SQL Server, SQL Server Agent, and Windows NT.
To view logs that are related to maintenance plans
In Object Explorer, expand Management, right-click Maintenance Plans, and then click
View History.
The logs include Database Mail, Job History, Maintenance Plans, Remote Maintenance
Plans, and SQL Server Agent.
To view logs that are related to Data Collection.

In Object Explorer, expand Management, right-click Data Collection, and then click View
Logs.
The logs include Data Collection, Job History, and SQL Server Agent.
To view logs that are related to Database Mail

In Object Explorer, expand Management, right-click Database Mail, and then click View
Database Mail Log.
The logs include Database Mail, Job History, Maintenance Plans, Remote Maintenance
Plans, SQL Server, SQL Server Agent, and Windows NT.
To view logs that are related to audits collections
In Object Explorer, expand Security, expand Audits, right-click an audit, and then click
View Audit Logs.
The logs include Audit Collection and Windows NT.

LOVELY PROFESSIONAL UNIVERSITY 41