You have been hired by your company to manage an instance of SQL Server 2008. The server contains severaluser-defined stored procedures that query the system databases.
You discover that queries against some systemdatabases are not returning the correct results. You decide to repair the corrupt system databases.
To achievethis, you want to start the SQL Server instance in single-user mode without using the minimal configuration.
Which command should you use to restart the instance?

A.
sqlservr.exe -f

B.
sqlservr.exe -x

C.
sqlservr.exe -m

D.
sqlservr.exe -s

Explanation:

You should use the sqlservr.exe -m command. The sqlservr.exe command is a command-line utility that allowsyou to start, stop, and pause an instance of SQL Server 2008. Specifying the -m parameter with the sqlservr.exe command starts a SQL Server instance in single-user mode. Starting a SQL Server instance in single-user modeis required when you experience a problem with system databases and want to repair them. You should not use the sqlservr.exe -f command because the -f parameter does start an instance of SQL Serverin single-user mode with the minimal configuration. The scenario stated you did not want to use minimalconfiguration. You should not use the sqlservr.exe -x command because the -x parameter does not start an instance of SQLServer in single-user mode. The -x parameter disables monitoring features, such as performance monitor counters. You should not use the sqlservr.exe -s
command because the -s parameter does not start an instance of SQLServer in single-user mode. The -s parameter starts a named instance of SQL Server.

Objective:
Monitoring and Troubleshooting SQL Server

Sub-Objective:
Identify SQL Server service problems.

References:
TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Technical Reference > Tools Reference >Command Prompt Utilities > sqlservr Application TechNet > TechNet Library > Server Products and Technologies > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > Administration > Managingthe Database Engine Services > Starting and Restarting Services > Using the SQL Server Service StartupOptions