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

[Former Member]

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

[sunny_pahuja2]

Hi,

You can also look on the SAP note 965908 where you can overcome traditional method using Database mirroring concept.

Thanks

Sunny

[Former Member]

Hi Deepak/Sunny,

Thanks for your feedback.

We are looking for the option @ DR only .As of now we do not want to configure HA.

Is their Any option at DB level possible like we are having in Oracle --> Graceful Switchover

Regards,

Sahil Garg

[Former Member]

Hi Deepak/Sunny,

Thanks for your feedback.

We are looking for the option @ DR only .As of now we do not want to configure HA.

Is their Any option at DB level possible like we are having in Oracle --> Graceful Switchover

Regards,

Sahil Garg

[sunny_pahuja2]

Hi,

I don't see graceful switch over is available for MSSQL as well. Then I think you have to follow your procedure. Because method which we suggested above help you to achieve both HA and DR.

Thanks

Sunny

[former_member188883]

Hi,

Please refer to below mentioned links for MSSQL database

http://synsol.eu/blog/2010/11/detailed-step-by-step-guide-to-create-an-hadr-configuration-in-denali-...

http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/DBMandLogShipping....

Hope this is useful.

Regards,

Deepak Kori

Note: There are 2 threads with the same query raised by you. Request you to close the other thread.