How to start a named instance of SQL Server with minimal configuration (Command Prompt)

How to start a named instance of SQL Server with minimal configuration (Command Prompt)

To start a named instance of SQL Server with minimal configuration

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

  sqlservr -c -f -s {instancename}

  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.