As in oracle if we are switching to DR than to again come back from DR to Production we are
having a option of Graceful Switchover to minimize the time to make the original Production live
We want to minimize the time to again switch back from DR to Primary.As in Oracle we are having
Graceful Switch over method.Any method like Graceful switchover do we have in SQL Server?
The standard below Procedure we are having..
1.Take the complete backup of DR DB once it is open for customer.
2.Copy the backup on Production Site. (It takes near about 2 days due to network speed)
3.Restore the DR DB on Production.
4.Apply all the latest logs available on DR site.
5.Take the downtime on DR site and apply all the latest logs on Production site and make the
system available for the end user.