Log Shipping over WAN
I have recently begun to roll out Log Shipping via SQL Backup between 2 SQL servers across our WAN. We have a 1.5mb private line connecting two locations, if the private line goes down the network will automatically failover to IPSEC VPN. I plan to schedule the shipping to occur every 15 minutes with a 5 minute delay.
I'm curious where you might recommend we store the files for sharing -- should the log backup job store the log file locally on the source server, or should it copy them to the destination server.
Advantage to storing locally on the source server is that the file is written quickly, and should pretty much be guaranteed to be written as there are no network variables involved. Should the network go down, the log backups would be queued up waiting to be picked up by the Log Restore Job on the desination server.
Disadvantage of storing locally on the source server is that the file must be read twice across the WAN by the destination server -- Once for the restore, and another for the MOVETO to the local backup folder once the restore is complete.
What does everyone recommend? Best practice?