Start or Stop SQL Services using SQLCMD
In one of my previous post "SQLCMD Mode - Run your queries against several servers in a single query window.", i had explained on how to connect and execute queries in SQLCMD mode.
Hope that was useful.
In this post i will explaining on how to stop and start SQL Server services using SQLCMD mode.
First of all, Open a new query window and Change the query execution mode to SQLCMD.
Then type the below command in the new query window that is opened in the SQLCMD mode.
1. To start the services, use the below commands
/* Start Services */
2. To stop the services, use the below commands
/* Stop Services */
If you are trying to start or stop a default instance, then then will no changes to the above query.
If you are trying to start or stop a named instance, then Replace MSSQLSERVER with your instance name.
For example, if you are trying to start or stop the named instance "SQL2008", then the commands will look as below.
Hope that was useful.
In this post i will explaining on how to stop and start SQL Server services using SQLCMD mode.
First of all, Open a new query window and Change the query execution mode to SQLCMD.
Then type the below command in the new query window that is opened in the SQLCMD mode.
1. To start the services, use the below commands
/* Start Services */
!!NET START MSSQL$MSSQLSERVER
!!NET START SQLAGENT$MSSQLSERVER
/* Stop Services */
!!NET STOP SQLAGENT$MSSQLSERVER
!!NET STOP MSSQL$MSSQLSERVER
If you are trying to start or stop a named instance, then Replace MSSQLSERVER with your instance name.
For example, if you are trying to start or stop the named instance "SQL2008", then the commands will look as below.
/* Stop Services */
!!NET STOP SQLAGENT$SQL2008
!!NET STOP MSSQL$SQL2008
/* Start Services */
!!NET START MSSQL$SQL2008
!!NET START SQLAGENT$SQL2008
No comments:
Post a Comment