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.
Explanation:
Reference: http://msdn.microsoft.com/en-us/library/ms186400.aspx
Reference: http://msdn.microsoft.com/en-us/library/ms345408.aspx
Wouldn’t the answer be A? The issue here is a disk failure, so it makes sense to me that you would have to tell SQL Server to create tempdb elsewhere…
Hi Brian. I believe you would have have trouble starting the instance without the volume hosting TempDB (the path information in the mdf would be pointing to the dead volume on start-up). You would not be able to modify the path without the instance running first and the only way you can start the instance here is from a command prompt in minimal configuration mode (net start…). Once the instance is running, you can then change the path using sqlcmd…
At this stage of the game I am banking on ‘B’
B
http://sqlserverdb.blogspot.ch/2012/04/how-to-start-sql-server-without-tempdb.html