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: 4274 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

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