How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
SQL Server can be started from command line, using the SQLSERVR.EXE. This EXE has some very important parameters with which a DBA should be familiar with. -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.
Related Questions
- How do I configure Setup Manager to build configuration sets that use a user name and password that is different from the user name and password that I used when I first installed the OPK?
- How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?
- What is the preferred way of performing Setup and Configuration for Enterprise mode?