question

mukki avatar image
mukki asked

Log Shipping

I have two node SQL server standard failover cluster. I need to setup single node DR using log Shipping method. Want to ask after switch over to DR how we can setup, plan so that application can connect automatically to DR database server without any changes on application connection string. Thanks

sql-server-2008log-shippingconnectionfailoverdisaster-recovery
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
anthony.green avatar image
anthony.green answered

You're going to need to change the connection string one way or another to do this.

The major issue is once you have invoked DR, you bring up the DR server, rename it etc etc so it thinks its the same name as PROD. After while you bring up the PROD site, you now have the cluster back online and the DR node online with the SAME name, how are you going to handle that?

What I would do is to create a new DNS CNAME entry, something that is not the PROD cluster VNN or the DR name.

Set the CNAME to point to the PROD cluster name.

Change the application connection strings to be the new CNAME

When you invoke DR you simply change the CNAME to point to the DR name instead, then when you fail back to the PROD site you simply repoint the CNAME.

That way your not messing with the applications, all you do is wait for the DNS change to propagate so then you push that back to your Windows/Domain admins to ensure you have fast propagation happening.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.