High availability and automatic failover

• joujousagem2006 1602

  SSCommitted

  Points: 1779

  More actions

  October 25, 2018 at 2:01 pm

  #375874

  Hello,

  I implemented a solution using availability groups with two replica (primary and secondary).
  in automatic failover mode, and synchronous validation.
  I created a list to allow access to client applications.

  the cluster is operational on the primary replica, I performed a test to simulate the failover by stopping the SQL SERVER instance on the primary,
  failover is successfully completed on the secondary, and then I tried to re-enable the SQL SERVER instance on the primary, but the cluster still remains on the secondary.

  is there way that the failover is done automatically on the primary server after recovery of the instance.

  Regards,

• Beatrix Kiddo

  SSC-Dedicated

  Points: 32407

  More actions

  October 29, 2018 at 3:06 am

  #2011488

  That's expected behaviour. There's no designated, permanent "primary" replica, just whatever is primary right now. It's working correctly.