Which log should you examine?

You administer a SQL Server 2008 instance.
A SQL Server Agent job executes every 2 minutes. The job logs information to a text file
named SQL1.log located on the E: drive.
Users report that the server is unresponsive. You discover the following problems:
-The SQL Server Agent job no longer functions. -The SQL Server Agent service does not
run.
You need to find out the cause of the SQL Server Agent service failure.
Which log should you examine?

You administer a SQL Server 2008 instance.
A SQL Server Agent job executes every 2 minutes. The job logs information to a text file
named SQL1.log located on the E: drive.
Users report that the server is unresponsive. You discover the following problems:
-The SQL Server Agent job no longer functions. -The SQL Server Agent service does not
run.
You need to find out the cause of the SQL Server Agent service failure.
Which log should you examine?

A.
SQL1.log

B.
log_xx.trc

C.
ERRORLOG

D.
SQLAGENT.OUT



Leave a Reply 0

Your email address will not be published. Required fields are marked *