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
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?