How to restart SQL Server in single user mode?

Posted by

To view Verified answers click on the button below.

How to restart SQL Server in single user mode? How to start SQL Server in
minimal configuration mode?

SQL Server can be started from command line, using the SQLSERVR.EXE. This EXE has
some very important parameters with which a DBA should be familiar with. -m is used for
starting SQL Server in single user mode and -f is used to start the SQL Server in minimal
configuration mode. Check out SQL Server books online for more parameters and their
explanations.