Administering a SQL Database Infrastructure — Question 90

You install Microsoft SQL Server 2016 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?

Answer options

• 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\MSSQL11.MSSQLSERVER\MSSQL\DATA\mastlog.idf
• D. %programfiles%\Microsoft SQL

Correct answer: A

Explanation

The correct answer is A, as the Errorlog file contains critical information regarding the SQL Server service startup process and any errors encountered. Options B and C are not directly related to the service startup failure; B is for installation logs and C refers to a database file, while D is incomplete and does not specify a relevant file.