SQL Server - stop services using bat file

Asked By pardhiveswar via SQLMonster.com

18-Nov-09 08:05 PM

HI,

I have 2 bat files one for to stop the service and the other to start the
service.

start service will be done using sp_procoption

basically i need to stop the service on the existing node whenever the
instance is failover to another node..or instance is stopped

Can some one tell me how to run a *.bat file when the instance is stopped



THanks in advance..

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-security/200911/1

20-Nov-09 11:30 AM

Can you clarify exactly you would like to accomplish?


The SQL service would be stopped on this node if the instance is failed over
to the other node. You do not need to stop it unless you are talking about
some other non-SQL service?

Linchi

24-Nov-09 12:00 PM

Sorry for the delay,

Actually we are using performance analysis for sqlserver(PASS)  in polyserver
cluster environment
for that it will create (PASS)services on primary and backup nodes..

polyserver does not have the ability to stop the service on the existing node
and start the service on the backup node when a failover occurs

Thats why we are looking for all other options...

Thanks Pardhi





--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-security/200911/1