Availability Group switch

• Shelley Allen

  SSCrazy

  Points: 2146

  More actions

  May 8, 2018 at 8:30 am

  #334581

  How can I change Availability Replicas Role from Secondary to Primary and Primary to Secondary
  Right Click AG
  Go to Properties
  Server Instance that is in Role Secondary needs to be Primary
  Server Instance that is in Role Primary needs to be Secondary

  I use Synchronous commit

  We are making our DR site PROD

  Thank you,

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736222

  More actions

  May 8, 2018 at 9:01 am

  #1989711

  Failover manually. First sentence: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/failover-and-failover-modes-always-on-availability-groups?view=sql-server-2017