Search This Blog

Friday, April 11, 2014

Start or Stop SQL Server Services using 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

No comments:

Post a Comment