To drop companion mode, issue:
sp_companion companion_name, "drop"
Dropping companion mode is an irreversible process; you must reconfigure the Adaptive Servers companion servers before you they will failover in a high availability system and retain all the functionality that Sybase’s Failover provides. However, the nodes upon which the Adaptive Servers are running are still a monitored by the high availability subsystem.
In Asymmetric configuration, login to the secondary (PERSONNEL1), do:
sp_companion MONEY1, “drop” go
In Symmetric configuration, do the above and then login to the primary (MONEY1), do:
sp_companion PERSONNEL1, “drop” go
