Script to stop SQL Server

The reason that you might want to stop SQL server is when databases live on servers other than the local SQL server, they might get corrupted on reboot. This causes you hours of restores. If you want to prevent this, create and run this batch file before rebooting your SQL server:


Net Stop "SQL Full-text Filter Daemon Launcher (MSSQLSERVER)"
Net Stop "SQL Server Agent (MSSQLSERVER)"
Net Stop "SQL Server CEIP service (MSSQLSERVER)"
Net Stop "SQL Server Integration Services 13.0"
Net Stop "SQL Server Integration Services CEIP service 13.0"
Net Stop "SQL Server Reporting Services (MSSQLSERVER)"
Net Stop "SQL Server VSS Writer"
Net Stop "SQL Server (MSSQLSERVER)"
pause
Share on Google Plus

About Tom DeMeulenaere

Highly accomplished information technology professional with extensive knowledge in System Center Configuration Manager, Windows Server, SharePoint, and Office 365.
    Blogger Comment

0 comments:

Post a Comment