How to start / stop SQL SERVER services using batch processing

Editor to share with you how to use SQL SERVER service batch start / stop, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Then leave some non-windows essential services such as sql server turned on, and then start them with batch processing when you use them:

First set the SQL SERVER-related service startup type in Control Panel-> Administrative tools-> Services to manual (services starting with SQL Server), then create a new text document and change the suffix to "bat". Let's add a batch command:

1. Start SQL SERVER.bat

The code is as follows:

@ echo. The service is started. @ echo off @ sc start MSSQLSERVER @ sc start SQLSERVERAGENT @ sc start MSSQLServerOLAPService @ sc start msftesql @ sc start MsDtsServer @ sc start SQLWriter @ echo. Activation complete! @ pause

two。 Stop SQL SERVER.bat

The code is as follows:

@ echo. The service is stopped. @ echo off @ sc stop SQLSERVERAGENT @ sc stop MSSQLServerOLAPService @ sc stop msftesql @ sc stop MsDtsServer @ sc stop SQLWriter @ sc stop MSSQLSERVER @ echo. Stop! over! @ pause

The specific usage of the sc (server control) command can be viewed with the "sc-help" command, or searched on the Internet. After these two batch files are established, it is convenient to execute the batch file "start SQL SERVER.bat" when you run SQL Server 2005 and "stop SQL SERVER.bat" when you exit.

The above is all the contents of the article "how to start / stop SQL SERVER Services using batch processing". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!