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
A
A
https://msdn.microsoft.com/en-us/library/ms187885.aspx
http://www.aiotestking.com/microsoft/which-file-should-you-use-4/
A
The error log is located at Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG and ERRORLOG.n files.