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

 Posted by Bharathi Cherukuri on 4/30/2012 | Category: Sql Server Interview questions | Views: 2432 | 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 

Comments or Responses

Login to post response