PrepAway - Latest Free Exam Questions & Answers

You need to be able to start the SQL Server

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?

PrepAway - Latest Free Exam Questions & Answers

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.

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

4 Comments on “You need to be able to start the SQL Server


Leave a Reply