Distributed Availability Group Failover test without affecting Primary site

• kp_kumar

  Mr or Mrs. 500

  Points: 534

  More actions

  November 3, 2020 at 7:46 pm

  #3804010

  Hi

  I have created a test environment with Distributed Availability Group (SQL 2016)  for DR Testing and I can fail over to DR. Now I need to test the DR site databases with application. To avoid the test data sync  back  to Production site, i have to drop the Distributed AG.

  Is there any way I can do the test with out breaking the Distributed Availability Group by pausing all transactions from Primary and do the test on DR site and resume Distributed AG with out any change in Primary site?

  Thanks

   

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  November 4, 2020 at 8:10 pm

  #3804384

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.