快速启动、停止SQL2008服务

最新推荐文章于 2024-07-23 03:59:55 发布

转载最新推荐文章于 2024-07-23 03:59:55 发布 · 3.2k 阅读

文章标签：

#sql server #sql #vss #search

C/C++ 同时被 2 个专栏收录

4 篇文章

订阅专栏

DB/SQL/MYSQL

1 篇文章

订阅专栏

本文提供了一组用于启动和停止SQLServer2008服务的批处理脚本。脚本中包括了针对核心服务如SQLServer、AnalysisServices、FullTextSearch等的管理命令。

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