SQL2005服务BAT

启动：

@echo.正在启动MS Server 2005相关服务，请等待 ... ...
@echo off
@net start MSSQLSERVER
@net start SQLSERVERAGENT
@net start MSSQLServerOLAPService
@net start msftesql
@net start MsDtsServer
@net start SQLBrowser
@net start ReportServer
@echo off
@echo.启动完毕！
@pause

 

关闭：

@echo.正在关闭MS Server 2005相关服务，请等待 ... ...
@echo off
@net stop SQLSERVERAGENT
@net stop MSSQLServerOLAPService
@net stop msftesql
@net stop MsDtsServer
@net stop SQLBrowser
@net stop MSSQLSERVER
@net stop ReportServer
@echo off
@echo.停止完毕！
@pause

 

注：

SQLBrowser                 对应 SQL Server Browser  //可以禁用

msftesql                       对应 SQL Server FullText Search

ReportServer               对应 SQL Server Reporting Services

MsDtsServer                对应 SQL Server Integration Services

MSSQLServer               对应 SQL Server

SQLSERVERAGENT       对应 SQL Server  Agent

MSSQLServerOLAPService 对应 SQL Server Analysis Sservices