I know that I can have a maintenance plan do a Full Backup to a local drive as well as a UNC path so that I have it off-server in case the server is destroyed.
I'd like to do Transaction log backups so that I can do a point-in-time recovery. I'm thinking that I can't just do the same thing because then the sequence of the transaction logs would be mixed across the two backup destinations.
i.e. If I do a transaction log each hour to locations A and B, the last transactions going to B won't include the ones that went to A.
If there's no way around that, I'm thinking the best way to do it would be to do the Transaction log backups only to the local drive and then have a Robocopy to periodically send them to the UNC location.
Am I missing something? Any help much appreciated!