How to stop a named instance of SQL Server (Command Prompt)

To stop a named instance of SQL Server

• From a command prompt, enter:

  net stop mssql$instancename

Note  Stopping a named instance of Microsoft® SQL Server™ 2000 using SQL Server Enterprise Manager or the net stop mssql$instancename command causes SQL Server to perform a checkpoint in all databases. Then a SHUTDOWN WITH NOWAIT is done to flush all committed data from the data cache and to stop the server immediately. Stopping a named instance of SQL Server 2000 from the command prompt works only if you are running Microsoft Windows NT® 4.0 or Windows® 2000.