Adding a Second Log Shipping Secondary Instance
Posted on 2014-02-28
I already log ship my main databases to another local server and now I need to also log ship to another physical DR location via a slower WAN connection.
My plan was to bring over the full backup of these databases ( which are quite large) and restore with standby in preparation to start log shipping to the DR site.
My question is this: how do I handle the incremental transaction log changes? Normally when doing this for the first secondary instance I restore a full backup and then a current trans log backup before starting log shipping, I imagine doing that for a second instance will create an LSN problem for the existing log shipping instance? Do I do a differential instead?
Thanks for the help.