I am currently in the planning process of a DR testing(Mirroring Failover) and I need some clarification for couple of the steps that I need to provide.
Here is my scenario......we will be failing over a mirror database from Prod to DR and application team will be doing some testing on the DR side after I failover, however, when I failback to Prod, we do not want to carry over the testing changes app team made on the DR side. So, I was thinking to do the following steps to accomplish that but I need to confirm if there is any other better work around.
-Backup the prod database before failover.
-Failover the database from Prod to DR
-Once the failover is done and all mirroring is synchronized, I will remove mirroring.
-Application team start their testing at this point.
-During this time I will copy the backup file that I took earlier to DR server.
-Once the testing is done, I will restore the DR database with the Prod backup
-Then setup mirroring between DR and Prod
-Now, failback the database from DR side to Prod and we will have the same data on both DR and Prod as before the failover.
Does these steps seem correct? Can you guys think of a better way to accomplish this? Please advise.