You install Windows Essential Business Server 2008 Premium Edition on the network. The Database Server is named EBS-DBSrv. The EBS-DBSrv server contains a default instance and a named instance of SQL Server 2008. A user reports that a database in the named instance has become corrupt. You want to repair the database. To achieve this, you want to start the named instance of SQL Server 2008 in single-user mode.
Which two commands can you use to restart the instance? (Choose two. Each correct answer presents a complete solution.)
A.
Sqlservr.exe -m -s
B.
Sqlservr.exe -m -x
C.
Sqlservr.exe -m -n
D.
Sqlservr.exe -m -f
E.
Sqlservr.exe -m -c
Explanation:
You can use either the Sqlservr.exe -m -s command or the Sqlservr.exe -m -n command. The Sqlservr.exe command is a command-line utility that allows you to start, stop, and pause an instance of SQL Server 2008. When you specify the -m parameter with the Sqlservr.exe command, SQL Server starts in single-user mode. To start a specific named instance in single-user mode, you can use the -s parameter or the -n parameter with the -m parameter. The -s parameter is used to start a named instance of SQL Server. If you do not specify any named instance with the -s parameter, the default instance of SQL Server is started. The -n parameter is also used to start a named instance of SQL Server without using the Windows application log to record SQL Server events. When you want to start a named instance by using the -n parameter, you should also specify -s parameter because if you do not specify the -s parameter with the -n parameter, the default instance attempts to start.You should not run the Sqlservr.exe -m -x command because this command does not allow you start a named instance of SQL Server 2008 in single-user mode. The -x parameter disables monitoring features, such as performance monitor counters.
You should not run the Sqlservr.exe -m -f command because this command does not allow you start a named instance of SQL Server 2008 in single-user mode. The -f parameter starts an instance of SQL Server with minimal configuration.
You should not run the Sqlservr.exe -m -c command because this command does not allow you start a named instance of SQL Server 2008 in single-user mode. The -c parameter shortens startup time when starting SQL Server from the command prompt.