Recovering from a failed prepare_failback

During fail back, if prepare_failback was executed successfully on the secondary companion but the primary companion does not start, perform the following to roll back and then reissue the prepare_failback command:

  1. Check the primary companion’s system event log to find the reason the server does not start, and correct the problems.

  2. Check that the MSCS group that contains the resource for the primary server is located on the secondary node. If not, it does use Move Group to move it.

  3. Log in to the secondary companion and issue:

    dbcc ha_admin ("", "rollback_failback")
    dbcc ha_admin ("", "rollback_failover")
    
  4. Verify that the secondary companion is in normal companion mode.

  5. Check that the MSCS resource for the primary server is online. If it is not, manually bring the resource online using the Cluster Administrator.