SQL 2005 proper service stop/start order
Posted on 2008-10-06
I am setting up a SQL 2005 server. I'm trying to figure out what the best way to take a monthly image of the server. We are using Symantec Livestate Server Ed. Looking at the SQL Server configuration manager -> services there are 7 SQL services:
SQL Server Integration
SQL Server FullText Search
SQL Server Analysis
SQL Server Reporting
SQL Server Browser
SQL Server Agent
I want to create a batch job that stops the services before the imaging software kicks off and another batch job that restarts the services after the imaging is done. SQL server is a stand alone server.
I've googled this question but I can't seem to find anything that says in what order these services need to be stopped and then restarted.