How to start SQL Server (Command Prompt)

To start SQL Server

• From a command prompt, enter this command to start Microsoft® SQL Server™ independently of the Service Control Manager:

  Sqlservr.exe

Examples

This example shows how to start SQL Server from a command prompt using C:\Mssql7\Data\Master.dat as the master database file path and C:\Mssql7\Log\Errorlog as the error log path:

sqlservr -c -dc:\mssql7\data\master.dat -ec:\mssql7\log\errorlog

See Also

Starting SQL Server Manually