PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

A.
SQL1.log

B.
log_xx.trc

C.
ERRORLOG

D.
SQLAGENT.OUT


Leave a Reply