SQLTeam.com | Weblogs | Forums

Log Shipping

I have 2 node on DC as standard cluster
On 3rd node I will setup log Shipping using ip address

During Switchover dr db host will be assigned same host as of primary but with different ip.

Is this workable.

SQL instance name needs to change to same as primary to connect application without changes.