You are the database administrator of your company. You configure a new SQL Server Agent job on a SQLServer 2008 computer named SQL1.
You confirm that the job runs successfully. After a month, you discover that the SQL Server Agent has stopped unexpectedly.
You try to start the SQL ServerAgent manually but the agent will not start. You want to identify the cause of the problem. Which file should you check?
A.
C:Program FilesMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLLogSQLAGENT.1
B.
C:Program FilesMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLLogSQLAGENT.OUT
C.
C:Program FilesMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLLogERRORLOG
D.
C:Program FilesMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLLogERRORLOG.1
Explanation:
You should check the C:Program FilesMicrosoft SQLServerMSSQL10.MSSQLSERVERMSSQLLogSQLAGENT.OUT file. The SQLAGENT.OUT file is the defaultSQL Server Agent log, which contains information about errors related to SQL Server Agent. This file is located in the C:Program FilesMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLLog
folder by default. Tochange the location where the file is stored, you should perform the following steps:1. Open SQL Server Management Studio, and expand the SQL Server Agent node.2. Right-click the Error Logs node, and click the Configure option.3. In the Configure SQL Server Agent Error Logs dialog box, specify the new file name and path in the Error log file
field.You should not check the C:Program FilesMicrosoft SQLServerMSSQL10.MSSQLSERVERMSSQLLogSQLAGENT.1 file. The SQLAGENT.1 indicates an archivederror log. SQL Server maintains up to nine error logs that contain information about errors related to SQL ServerAgent. These archived logs are given extensions from .1 to .9 , which indicate the age of the log file. The .1 extension indicates the latest archived error log. To find information about recent errors related to SQL ServerAgent, you should check the current SQL Server Agent error log, which is SQLAGENT.OUT by default. You should not check the C:Program FilesMicrosoft SQLServerMSSQL10.MSSQLSERVERMSSQLLogERRORLOG file or the
C:Program FilesMicrosoft SQLServerMSSQL10.MSSQLSERVERMSSQLLogERRORLOG.1 file. The ERRORLOG and ERRORLOG.1 filesare SQL Server error logs that record information about server-level error messages. These logs do not containinformation about SQL Server Agent errors. To find information about recent errors related to SQL Server Agent,you should check the current SQL Server Agent error log, which is SQLAGENT.OUT by default.Objective:
Monitoring and Troubleshooting SQL Server
Sub-Objective:
Locate error information.References:
TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > SQL Server Database Engine > Administering the DatabaseEngine > Automating Administrative Tasks (SQL Server Agent) > SQL Server Agent > Using the SQL ServerAgent Error Log MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Technical Reference > SQL-DMOReference > Properties (SQL-DMO) > A (SQL-DMO Properties) > AgentLogFile Property