I have two remote DBs that I need to backup on remote servers using the SQLBAckupAndFTP free edition (the DBs are tiny).
I use the Microsoft SQL Server (remote) and configure the backup. The databases need separate logins so I configure 2 jobs one for each. When configured each job runs successfully. Once they are scheduled then one fails. If I delete it and recreate then it runs the first time but either that or the other job fails. The error appears to be:
29/09/2020 00:15:19 [Error] Failed to backup “DATABASE_NAME” database with “Full” backup type: Backup media not found: “C:\WINDOWS\system32\config\systemprofile\AppData\Local\Temp\SYSTEM\Pranas.NET\SQLBackupAndFTP\backup\DATABASE_NAME202009290015.sql”.
Any help on resolving this would be greatly appreciated. The two jobs run at 00:15 and 00:30 if that would make any difference.