How to start the default instance of SQL Server with minimal configuration (Command Prompt)

SQL Server Setup Help

SQL Server Setup Help

How to start the default instance of SQL Server with minimal configuration (Command Prompt)

To start the default instance of SQL Server with minimal configuration

  • From a command prompt, enter the following command to start the default instance of Microsoft® SQL Server™ as a service:

    sqlservr -c -f

    Note  You must switch to the appropriate directory (for the instance of SQL Server you want to start) in the command window before starting sqlservr.exe.

See Also

Starting SQL Server Manually