You install Windows Essential Business Server 2008 Premium Edition on the network. The Database Server is named SQL1 and runs a single instance of SQL Server 2008. You discover that the msdb system database is not functioning properly. You want to repair the system database. To achieve this, you want to restart SQL1 in single-user mode.
Which command should you use to restart the instance?
A.
Sqlservr.exe -s
B.
Sqlservr.exe -x
C.
Sqlservr.exe -n
D.
Sqlservr.exe -m
Explanation:
You should run the Sqlservr.exe -m command. The Sqlservr.exe command-line utility allows you to start, stop, and pause an instance of SQL Server 2008. This utility is typically used to troubleshoot SQL server issues or to perform major maintenance on the server. The -m parameter specified with the Sqlservr.exe command starts an instance of SQL Server in single-user mode.When you run SQL Server from the command line, SQL Server runs in the security context of the user and not the security context of the account assigned to run SQL Server during setup. Therefore, when starting SQL Server from the command line, you must ensure that the account you use has appropriate permissions to start SQL Server. When starting an instance of SQL Server, you must use the sqlservr.exe utility in the appropriate directory for that instance. For the default instance, you should run the sqlservr.exe utility from the MSSQLBinn directory. For a named instance, you should run the sqlservr.exe utility from the MSSQL$instance_nameBinn directory.
You should not run the Sqlservr.exe -s command because the -s parameter does not cause an instance of SQL server to start in single-user mode. The -s parameter starts 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.
You should not run the Sqlservr.exe -x command because the -x parameter does not cause an instance of SQL server to start in single-user mode. The -x parameter disables monitoring features, such as performance monitor counters.
You should not run the Sqlservr.exe -n command because the -n parameter does not cause an instance of SQL server to start in single-user mode. The -n parameter starts 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 the -s parameter because if you do not use both parameters, the default instance will attempt to start.