How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
Interview question and answer by: Bharathi Cherukuri
| Posted on: 4/30/2012 | Category: SQL Server Interview questions
| Views: 901 | | Points: 40
SQL Server can be started from command line, using the SQLSERVR.EXE.
This EXE has important parameters with which a DBA should be familiar with.
1) -m is used for starting SQL Server in single user mode
2) -f is used to start the SQL Server in minimal configuration mode.
| Alert Moderator
Found interesting? Add this to: