How to: Start SQL Server with Minimal Configuration
Leave a reply
When you encounter configuration problem that prevent SQL Server from starting, you may need to start an instance using the minimal configuration option. This is the start up option -f. Starting an instance of SQL Server with minimal configuration automatically puts the server in single-user mode.
Kindly not what you can do when you start an instance of SQL Server in minimal configuration mode, as below:
- Only a single user can connect, and the CHECKPOINT process is not executed.
- Remote access and read-ahead are disabled.
- Startup stored procedures do not run.
After the server has been started with minimal configuration, you should change the appropriate server option value or values, stop, and then restart the server.
sqlservr.exe -c -f -s <Instance_Name> |
