Microsoft Exam Questions

Which file should you use?

You install Microsoft SQL Server 2012 on a new server.
After setup is complete, you attempt to start the SQL Server service. After being in a starting state
for a few moments, the service goes back to a stopped state.
You need to determine the cause of the failure.
Which file should you use?

A.
%programfiles%\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\Errorlog

B.
%programfiles%\Microsoft SQL Server\110\Setup Bootstrap\Log\Summary.txt

C.
%programfiles%\Microsoft SQL Server\110\Shared\ErrorDumps\SQLDmpr[XXXX].mdmp

D.
%programfiles%\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\mastlog.ldf