SQLTeam.com | Weblogs | Forums

Log Shipping

Dear experts

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

Have a look at this, it has multiple scenarios

Any other suggestions and link, pl share