Sunday, April 8, 2012

Start/Stop SQL Server from command line


You can using the following script to start/stop SQL Server services using command line:

SQL Server Database Engine(both SQL Server service and SQL Server Agent):
NET STOP SQLSERVERAGENT
NET STOP MSSQLSERVER
NET START MSSQLSERVER
NET START SQLSERVERAGENT

SQL Server Reporting Services:
NET STOP ReportServer
NET START ReportServer

SQL Server Analysis Services:
NET STOP MSSQLServerOLAPService
NET START MSSQLServerOLAPService

3 comments:

  1. Hi! Once you have started your SQL Server, you can use its commands to work with it:
    http://runakay.blogspot.com/2013/03/executing-sql-script-from-command-line.html

    ReplyDelete
  2. Line stopping also known as stopple with a hot tap, hot tap has been completed, then another machine.

    ReplyDelete
  3. The stopple method is used to insert a plugging into a pipe which is temporarily block sections of live pipelines. This method is used for a number of reasons like the affected section of a pipeline could be tapped, plugged and safety isolated without shutting down.

    ReplyDelete