Similar to the MirrorDirectory parameter, I'd like to have a way to write backups alternatively to 2 (or more) locations.
In my environment, I have 2 file servers dedicated to SQL Backups, and for now, I had to create two equivalent jobs, one pointing to FS1, scheduled even days, and the other pointing to FS2, scheduled on odd days. It gets even more complex when I add the log backups, and I have to ensure the same location.
If I could get a single job, with the parameter SpanDirectories, that would be a life-changer.
Thanks for considering this option.
Similar to the MirrorDirectory parameter, I'd like to have a way to write backups alternatively to 2 (or more) locations. In my environment, I have 2 file servers dedicated to SQL Backups, and for now, I had to create two equivalent jobs, one pointing to FS1, scheduled even days, and the other pointing to FS2, scheduled on odd days. It gets even more complex when I add the log backups, and I have to ensure the same location. If I could get a single job, with the parameter SpanDirectories, that would be a life-changer. Thanks for considering this option.