Start/stop SQL Server service using batch processing

Personal PCs are generally used to speed up startup and minimize service startup. Especially as a developer, if the home computer is not configured high, the startup speed is obviously slow after the SQL Server is installed, so let some non-Windows Services such as SQL Server do not start up, and then use batch processing to start it when it is used:

First, set the SQL Server-related Service Startup Type in "Control Panel> Administrative Tools> Services" to manual (Services starting with SQL Server), and create a new text document, change the suffix to "Bat ". Add the batch processing command below:

1. Start SQL Server. bat

@ Echo. Start the service ......
@ Echo off
@ SC start MSSQLServer
@ SC start SQLServerAgent
@ SC start mssqlserverolapservice
@ SC start msftesql
@ SC start msdtsserver
@ SC start sqlwriter
@ Echo off
@ Echo. started!
@ Pause

2. Stop SQL Server. bat

@ 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 off
@ Echo. Stopped!
@ Pause

The specific usage of the SC (Server Control) command can be viewed using the "SC-help" command, or you can search online. After these two batch files are created, when SQL Server 2005 is run, run "start SQL Server. bat "indicates the batch processing file. When you exit, execute" Stop SQL Server. bat ", very convenient.