Backup to a destination having two possible addresses, is it possible?

Unfortunately the ping test on Windows doesn’t produce consistent error result. It will return “success” with “destination host unreachable” for instance.

You might be able to use something besides ping. Or if you want to use ping you might be able to adjust the approach per this post: Feature-Request: Start backup only if some host is available - #6 by ts678