Exportar (0) Imprimir
Expandir Tudo
EN
Este conteúdo não está disponível em seu idioma, mas aqui está a versão em inglês.

How to: Stop an Instance of SQL Server (net Commands)

The Microsoft SQL Server service can be stopped using Microsoft Windows net commands.

ms190236.note(en-US,SQL.90).gifNote:
To ensure an orderly shutdown, you should pause SQL Server and stop the SQL Server Agent service before stopping an instance of SQL Server. You can do both using net commands, or SQL Server Configuration Manager.

  1. From a command prompt, enter one of the following commands:

    net stop "SQL Server (MSSQLSERVER)"

    -or-

    net stop MSSQLSERVER

  1. From a command prompt, enter one of the following commands. Replace instancename with the name of the instance you want to manage.

    net stop "SQL Server ( instancename )"

    -or-

    net stop MSSQL$ instancename

    ms190236.note(en-US,SQL.90).gifNote:
    Stopping an instance of SQL Server with the net stop command causes SQL Server to perform a checkpoint in all databases, saving all changed data to disk.

Contribuições da comunidade

ADICIONAR
Mostrar:
© 2014 Microsoft