Buscar contenidos

miércoles, 1 de julio de 2020

SQL SERVER – 2005 – Start Stop Restart SQL Server From Command Prompt

https://blog.sqlauthority.com/2007/09/09/sql-server-2005-start-stop-restart-sql-server-from-command-prompt/

SQL SERVER – 2005 – Start Stop Restart SQL Server From Command Prompt

Very frequently I use following command prompt script to start and stop default instance of SQL Server. Our network admin loves this commands as this is very easy.
Click Start >> Run >> type cmd to start command prompt.
Start default instance of SQL Servernet start mssqlserver
SQL SERVER - 2005 - Start Stop Restart SQL Server From Command Prompt netstart
Stop default instance of SQL Servernet stop mssqlserver
SQL SERVER - 2005 - Start Stop Restart SQL Server From Command Prompt netstop
Start and Stop default instance of SQL Server.
You can create batch file to execute both the commands together.
SQL SERVER - 2005 - Start Stop Restart SQL Server From Command Prompt netstartstop
Reference : Pinal Dave (https://blog.sqlauthority.com)

No hay comentarios:

Publicar un comentario