sqlServer服务启动bat

“启动SQL SERVER.bat”：

@echo.服务启动......
@echo off
@sc start MSSQLSERVER
@sc start SQLSERVERAGENT
@sc start MSSQLServerOLAPService
@sc start msftesql
@sc start MsDtsServer
@sc start SQLWriter
@echo off
@echo.启动完毕！
@pause

 

“停止SQL SERVER.bat”：

@echo.服务停止......
@echo off
@sc stop SQLSERVERAGENT
@sc stop MSSQLServerOLAPService
@sc stop msftesql
@sc stop MsDtsServer
@sc stop SQLWriter
@sc stop MSSQLSERVER
@echo off
@echo.停止完毕！
@pause

 

注：若仅仅需要连接数据库进行增删改查操作，只需启动MSSQLSERVER
服务即可。