Failover AG to DR server in asynchronous mode

  • WebTechie

    SSChampion

    Points: 11387

    We had a DR test.  We had to failover our AGs to our DR server.  We have two replicas for HA which are in synchronous mode.  The DR replica is asynchronous.

    We did some tests while the DR server was primary.  Data was entered.

    Then we failed back to the production server.

    1.  The data that was entered while the DR replica was not found.
    2.  The failover possibly rolled back all of the databases.

    Any tips on failing over to a DR server which is asynchronous without losing data.  My initial thought is before failover, make it synchronous.

    I appreciate any thoughts and/or feedback.

    Thanks.

    Things will work out.  Get back up, change some parameters and recode.

  • Beatrix Kiddo

    SSC-Dedicated

    Points: 32407

    Yes, switch it to synchronous mode first and wait for it to sync up.

  • GregoryAJackson

    SSCrazy

    Points: 2794

    I was gonna say the same thing that Ol Beatrix Kiddo said.

    GAJ

    Gregory A Jackson MBA, CSM

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply