how to gracefully recover from a log file copy failure?
We currently log ship from many remote locations (via private T1s) to a central location. Sometimes, copying the log file from the remote location fails because of a T1 hiccup or some other minor occurence. When the next copy and restore happens, it of course throws an error because the LSNs are out of sequence.
Right now I just copy manually and all is good again, but is there a better automated way to grab the missing log file?