Jorg Klein found a smart way to stop and restart all SQL Server Services in 1 step. This saves a lot of time, because you no longer have to do it by hand!
Paste the code below into Windows Notepad and change the extension to .bat . When you run this file, the services restart!
START SCRIPT:
NET START “SQL Server Agent (MsSqlServer)”
NET START “MsSqlServer”
NET START “MsSqlServerOlapService”
NET START “ReportServer”
NET START “SQL Server Integration Services”
STOP SCRIPT:
NET STOP “SQL Server Agent (MsSqlServer)”
NET STOP “MsSqlServer”
NET STOP “MsSqlServerOlapService”
NET STOP “ReportServer”
NET STOP “SQL Server Integration Services”
Frequently asked questions
How do I start all SQL Server services at once?
Paste NET START commands into Windows Notepad and give the file the .bat extension. Run the file and all the services start. This idea comes from Jorg Klein.
How do I stop all SQL Server services with a batch file?
Put NET STOP lines in a .bat file, for example NET STOP "MsSqlServer". Run the file and all the services it names stop.
Which services are in the SQL Server start script?
SQL Server Agent (MsSqlServer), MsSqlServer, MsSqlServerOlapService, ReportServer and SQL Server Integration Services.
How do I make a .bat file for SQL Server services?
Paste the NET START or NET STOP lines into Windows Notepad. Save the file and change the extension to .bat.
What is the benefit of a script to restart SQL Server services?
You no longer have to stop and start the services by hand. That saves a lot of time.
Comments
Related blogs
Analysis Services, Reporting and Excel 2007
Business Rules in the Data Warehouse
Analysis Services Enterprise vs Standard