PrepAway - Latest Free Exam Questions & Answers

Which three actions should you perform?

You manage a SQL Server 2005 computer that was installed using default settings. After a power failure, the SQL Server (MSSQLSERVER) service on your database server does not start.
You need to find out the cause of the problem. Which three actions should you perform? (Each correct answer presents part of the solution. Choose three.)

PrepAway - Latest Free Exam Questions & Answers

A.
In Event Viewer, view the system log.

B.
In Event Viewer, view the application log.

C.
In Notepad, view the C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGErrorLog.1 file.

D.
In Notepad, view the C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGErrorLog file.

E.
In Notepad, view the C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLAgent.out file.

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.
Although 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.


Leave a Reply