天天看点

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

服务即可。