Sql-server – SQL server Log Shipping

clusteringdisaster recoveryfailoverlog-shippingsql server

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

Best Answer

Without changes to application means you would have to do it at "the network layer". With that I mean things like DNS, rename machine etc.

If you can modify the connection string, then you can try below connection attribute. It is really meant for database mirroring, so you would have to try if it makes work in other situations:

Failover Partner=myMirrorServerAddress;

And, of course, make sure you handle all the other things that you have to handle when you move a database from one instance to another, like scheduled jobs, logins, linked servers etc. I.e., everything that is stored outside the database and is required for the system/application to be functioning.

Related Question