You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. Your duties at Domain.com include the administration of the SQL Server computer named Certkiller -DB03. Certkiller -DB03 was installed using default settings. A Domain.com employee named Clive Wilson is appointed as the junior technician in the Research and Development department. A power failure occurs. You detect that the SQL Server (MSSQLSERVER) service on your database server does not start. You instruct Clive Wilson to troubleshoot the error. What actions should Clive Wilson perform? (Choose all that apply)
A.
The C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLAgent.out file should be viewed in Notepad.
B.
The system log needs to be viewed in Event Viewer.
C.
Clive Wilson should view in Notepad the C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGErrorLog file.
D.
Clive Wilson should view in Notepad the C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGErrorLog.1 file.
E.
Clive Wilson should view the application log in Event Viewer.
Explanation:
To resolve database errors, you should review the SQL Server error logs and the Windows Application and the Windows System Event Log for errors. Even though a variety of informational messages is logged to each of these locations, any error with a severity level of 16 or higher automatically gets logged to the SQL Server error log and the Windows Application Event log. Errors with a severity of 16 or higher are critical errors that you need to investigate immediately.