Query to minimize the time to again switch back from DR to PRD

49 Views

Dear Mate,

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

again.

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.

Please suggest.

Sahil Garg