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
Answer by anthony.green ·
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.