Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
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
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.
