SQL Server in Single User Mode

Question

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

Jignesh Trivedi · Answer

hi SQL Server can be started from command line using the SQLSERVR.EXE . This EXE has some very important parameters -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. please refer http://blog.sqlauthority.com/2009/02/10/sql-server-start-sql-server-instance-in-single-user-mode/ hope this help.