You manage an instance of SQL Server 2008. You use SQL Server Agent to notify you of certain performanceconditions. You want to change the file to which SQL Server Agent will write error messages.
From which dialog box can you make this change?
A.
the SQL Server Agent Properties dialog box
B.
the Configure SQL Server Agent Error Logs dialog box
C.
the SQL Server Agent (MSSQLSERVER) Properties dialog box
D.
the Server Properties dialog box
Explanation:
You can change the file to which SQL Server Agent will write error messages from the Configure SQL ServerAgent Error Logs dialog box. By default, the information about errors related to SQL Server Agent are written to the C:Program FilesMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLLogSQLAGENT.OUT file.However, you can change this location by using the Configure SQL Server Agent Error Logs dialog box. To dothis, 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 select 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, as shown:
You cannot use the SQL Server Agent Properties dialog box to change the file to which SQL Server Agent willwrite error messages. This dialog box displays the error log file name on the General page, but it does not allowyou to change the file name or the file’s location. You cannot use the SQL Server Agent (MSSQLSERVER) Properties dialog box to change the file to which SQLServer Agent will write error messages. This dialog box is used to configure properties of the SQL Server Agentservice. You cannot use the Server Properties dialog box to change the file to which SQL Server Agent will write errormessages. The Server Properties dialog box is used to configure the server-level properties of the SQL server.
Objective:
Monitoring and Troubleshooting SQL ServerSub-Objective:
Locate error information.References:
MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Technical Reference > FeatureReference > SQL Server Management Studio F1 Help > Object Explorer F1 Help > SQL Server Agent F1 Help >Configure SQL Server Agent Error Logs (General Page) TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > Administration > AutomatingAdministrative Tasks (SQL Server Agent) > SQL Server Agent > Using the SQL Server Agent 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
