Hi Edd,
Thanks for reaching back out to us.
The Frequency of the export is really related to your needs in a Recovery Point Objective (data). RTO (Recovery Time Objective) is how long it takes for you to recover the system to a useful state. If your Recovery Point Objective is defined as 6 hours, then you only need to run the Export every 6 hours.
Also, if you are trying to reduce the number of orphaned assets in between backups, Repair - Reconcile component database from blob store will help reduce that situation.
On the topic of retrying the upload, yes we have seen customers add a retry when the upload fails. The delay time can be whatever you feel is appropriate.
Also, the amount of time it takes to export the databases will grow over time. As you add more components or versions, the export will take a little longer. I suggest giving yourself a little buffer in the timing and also review stats checking for growth and make adjustments as needed.
Hope all of this helps. Cheers!