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 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 monitored by the high availability subsystem.
In asymmetric configuration, log in to the secondary (PERSONNEL1), and enter:
sp_companion MONEY1, “drop” go
In symmetric configuration, do the above and then log in to the primary (MONEY1), and enter:
sp_companion PERSONNEL1, “drop” go
