2

I have a primary replica and one secondary. Multiple availability databases. Secondary replica is located at DR site.

For DR testing, is it possible to failover to the secondary replica, make (test) data changes on the secondary (now primary) replica and then failback but without moving back the test data?

I was thinking this may be possible through suspending data movement i.e.

  • Suspend data movement
  • Failover to secondary (DR server) replica
  • Insert test data
  • Failback to primary without synchronizing test data
  • Resume data movement
  • You have to force failover to primary with allow data loss. – Kin Shah Jul 13 '16 at 13:49
4

The short answer is No you cannot do that. First, if you suspend the data movement in one of the availability group database, you no longer able to failover it to your secondary node. Unless you make a forced failover. If you want to suspend the data movement in one of your databases, and also want to make the failover, you have to remove that specific database from the availability group and change the data. However, to add it back to the availability group, first you need to synchronize it back again.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.