Microsoft
70-432 · Question #8
70-432 Question #8: Real Exam Question with Answer & Explanation
The correct answer is B. You should check SQLAGENT.OUT. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance. There is a text file which is named SQL01.log on the E: drive. A SQL Server Agent job executes every 2 minutes and logs information to the text file. You get a report from users saying that the sever doesn't make response. As the technical support, you check and find that the SQL Server Agent service does not run and the SQL Server Agent job no longer functions. You have to identify the reason why the SQL Server Agent service is unresponsive. Which log should you check?
Options
- AYou should check SQL1.log
- BYou should check SQLAGENT.OUT
- CYou should check log_xx.trc
- DYou should check ERRORLOG
Community Discussion
No community discussion yet for this question.