How To Roll Back DR Transactions Without Breaking Mirror

by Michael Brule   Last Updated June 16, 2015 23:02 PM

We have a full data center DR test coming up and will need to fail over all of our SQL Server databases to the DR site. The majority (>80%) of our databases are SQL Server 2008 R2 using Database Mirroring for DR. The test duration is 56 hours. We have requirements to

  1. maintain production availability during the test,
  2. roll back any changes made during the test and
  3. resume normal operations (including re-establishing mirroring) within the time window allowed for the test.

The biggest issue we have is that we will need to break the mirror to allow both production and DR to be available for read/write. That forces us to take backups and copy them to DR to resume mirroring.

There are ~2,000 databases involved with over 4 TB of backup files. At those volumes it would not be possible to resume mirroring within the time frame allowed.

Does anyone have any ideas or know of any third-party software that would meet the requirements set down for this test?

I know Oracle has a Flashback feature which allows administrators to manually set a recovery point and roll back to that point when ready. Is there anything in SQL Server that could let us do that?

Related Questions

Best DR strategy for MS SQL Failover Cluster

Updated August 11, 2017 21:06 PM

SQL Snapshot Redirect

Updated June 17, 2018 11:06 AM

SQL Mirroring Locking/Blocking Contention

Updated June 17, 2018 02:06 AM