Designating a Failover Node

You must designate a failover node to continue the coordinator role in the event that the current coordinator is unable to continue.

  1. Start the server, connect to it, and issue a command in the following format:
    ALTER MULTIPLEX SERVER server-name ASSIGN AS FAILOVER SERVER
  2. The designated failover node defaults to the first multiplex server added to the multiplex.
Related concepts
Designated Failover Node
Related reference
sp_iqmpxinfo Procedure