代码改变世界

快速启动、停止SQL2008服务

2016-06-14 17:08  我在雨中等你  阅读(538)  评论(0)    收藏  举报 
1、启动SQL Server 2008服务.bat

    @echo off
    @ ECHO 启动SQL Server 2008 服务
    pause
    net start "SQL Server (MSSQLSERVER)"
    net start "SQL Server Analysis Services (MSSQLSERVER)"
    net start "SQL Server FullText Search (MSSQLSERVER)"
    net start "SQL Server Integration Services"
    net start "SQL Server Reporting Services (MSSQLSERVER)"
    net start "SQL Server VSS Writer"
    @ ECHO 启动完毕
    pause
    exit 



2、停止SQL Server 2008服务.bat

    @echo off
    @ ECHO 停止SQL Server 2008 服务
    pause
    net stop "SQL Server (MSSQLSERVER)"
    net stop "SQL Server Analysis Services (MSSQLSERVER)"
    net stop "SQL Server FullText Search (MSSQLSERVER)"
    net stop "SQL Server Integration Services"
    net stop "SQL Server Reporting Services (MSSQLSERVER)"
    net stop "SQL Server VSS Writer"
    @ ECHO 停止完毕
    pause
    exit