olahallengren
commented
2 weeks ago One challenge here would be the backup chain. Imagine that one log backup fails to the preferred location and is written to the backup location. Then you would need both locations in order to perform a restore.
For the backup capability: I have inherited servers that I am not allowed (by company policy). Backup jobs on either server are targeted at a shared folder. Currently, as configured, if I loose access to that shared folder, I need a fall back location for the backups to automatically be written to.
Using mirroring is not an option in our scenario. Documentation does not indicate that if the backup destination is not writable it would backup to the server's configured default location instead.