It looks like REPLICATION will likely be my preferred method as I DO wish to automate this.
@Mobius Buddy backup is a GREAT approach for offisite backups and one I will use and ask others the same, I just want to automate my writes from primary to secondary in keeping with the 3-2-1 rule - the "1" being when buddy backups are implemented. I'm still at "2" 😆