You are the database administrator of your company. Several users connect to an instance of SQL Server 2008 named SQL1.
A user reports that his session terminated unexpectedly. You want to identify the cause of theproblem.
In which two log files could you look to obtain additional information about the error? (Choose two. Each correctanswer represents a complete solution.)
A.
the Windows Application log
B.
the Windows System log
C.
the Windows Security log
D.
the SQL Server Error log
Explanation:
You can use the Windows Application log or the SQL Server Error log to obtain additional information about theerror. SQL Server records system events and user-defined events to the SQL Server Error log and the WindowsApplication log. All events that are related to SQL Server sessions are written to the Windows Application log.SQL Server reads these events from the Windows Application log and stores them in the SQL Server Error log,which can be viewed by using the SQL Server Log File Viewer.
You should not use the Windows System log or the Windows Security log because these logs do not containinformation about SQL Server sessions. The Windows System log contains events that are logged by theWindows operating system. The Windows Security log records security events such as failed login attempts.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 > Operations > Monitoring > MonitoringEvents > Monitoring the Error Logs > Viewing the Windows Application Log MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > Monitoring > MonitoringEvents > Monitoring the Error Logs