What should you do?

You administer a Microsoft SQL Server 2012 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:

References:

http://msdn.microsoft.com/en-us/library/ms186400.aspx

http://msdn.microsoft.com/en-us/library/ms345408.aspx