What should you do?

You administer a Microsoft SQL Server 2014 instance. After a routine shutdown, the drive that contains tempdb fails.

You need to be able to start the SQL Server.

What should you do?
A . Modify tempdb location in startup parameters.
B . Start SQL Server in minimal configuration mode.
C . Start SQL Server in single-user mode.
D . Configure SQL Server to bypass Windows application logging.

View Answer

Answer: B

Explanation:

If you have configuration problems that prevent the server from starting, you can start an instance of Microsoft SQL Server by using the minimal configuration startup option.

When you start an instance of SQL Server in minimal configuration mode, note the following:

Only a single user can connect, and the CHECKPOINT process is not executed.

Remote access and read-ahead are disabled.

Startup stored procedures do not run.

tempdb is configured at the smallest possible size.

References: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/start-sql-server-with-minimal-configuration