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
Answer:
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.
Asked In: Many Interviews
|
Alert Moderator
Found interesting? Add this to: