We have completed a working ASE_HA setup as Symmetric Active/Active.
ASE1N1 <-> ASE1N2
The failover/failback has been tested,
Once ASE1N1 failover to ASE1N2, immediately after the DBCC Takeover, we need to issue a commmand inside RUNHA_<SERVER> script using haisql to startup a listener.
The command is supposed to be something similar to below:
haisql -U<> -S<> -P<> <<!
sp_listener "start", "vip1:port1"
go
!
let us know, how we can embed such commands to bring up the second listener such that the legacy application can continue to connect seamlessly even after the failover.
this is needed as the application is legacy and cannot be made HA aware.
Awaiting your reply,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.