I’m trying SQLBackupAndFTP (Professional Trial v12.2.3) and something weird happens with schedules, I say this because if I trigger the process manually this issue never happens. The title sums the issue, but what bothers me is that it always errors out at 99% of the same DB (8GB) and resumes the last percent successfully 2 hours later. So really the backup is always successful but instead of taking 15 minutes it takes 2 hours and 15 minutes because of this weird timeout. Whenever I trigger the same backup task manually it is carried out successfully.
Another thing that I find hilariously idiotic is that when the schedule is running, the upload speed is capped at 1MB/s, but if I open SQLBackupAndFTP GUI then the speed starts raising immediately up to 10MB/s (max for the connection). How does this make any sense?
Any thoughts on any of this?