Hi - I sent this issue as a support request twice over the last several weeks, with no response, and now trying on the forum. I could really use some help.
I have set up a job for a client who needs weekly copies of their database backup from our server.
I ran a test of the job, and the log reports that the backup, compression, and upload were successful, but the file is not there in the client’s OneDrive folder.
The client cannot see it either, but he has confirmed he can see other files I upload to that folder manually, so my account has access and permissions. The test connection from SqlBackupandFTP job gives a “successful connection” message.
I let the job run as scheduled, and it returns a successful job message every week, but as with the manual run, the file was not in the specified OneDrive folder.
We are not sure what else to try. Any suggestions appreciated - thank you.
I just ran it manually again, log below.
Log below (db, user, and folder names changed)
Summary (Success)
Job: XXX weekly
Server: XXSQL
Date: 8/11/2025 10:26:26 AM
Backup type: Full
Backup archive size: 1.24GB
Database count: 1
XXData_XXX Database backup: 1.24GB “OneDrive for Business” - success
Next backup: 8/17/2025 3:00:00 AM - Full
Detailed Log:
• 10:26:26 AM : Starting job "XXX weekly " - “Full”. Server “XXSQL”. System account “SYSTEM@WORKGROUP”. App v.“12.6.13”.
• 10:26:26 AM : Connecting to “SQL Server”: “XXsql”.
• 10:26:26 AM : Connected to “2016 SP2 Express Edition (64-bit)”.
• 10:26:26 AM : The backup folder “C:\SQLData\Backup2016” has “31.814GB” free space. The temporary folder “C:\Windows\TEMP\SYSTEM\Pranas.NET\SBF\190f78d4-4b2a-452e-a4db-76e8ed28ad23” has “31.814GB” free space.
• 10:26:26 AM : Backing up “XXsql” SQL Server databases.
• 10:26:26 AM : The maximum file size for destination “OneDrive for Business: UserName”: “250GB”.
• 10:26:26 AM : Backing up “XXData_XXX” with “Full” backup type.
• 10:26:32 AM : Database “XXData_XXX” successfully backed up to “C:\SQLData\Backup2016\XXData_XXX202508111026.bak : 2.775GB”.
• 10:26:32 AM : Compressing “C:\SQLData\Backup2016\XXData_XXX202508111026.bak” file with Internal archiver. Encryption: “On”. Password: “**********”.
• 10:31:18 AM : Backup of “XXData_XXX” successfully compressed to “(XXData_XXX202508111026.zip : 1.243GB)”.
• 10:31:19 AM : Connecting to “OneDrive for Business” destination “UserName”.
• 10:31:20 AM : The current destination folder is “/Projects/Backups”.
• 10:31:20 AM : Sending backup of “XXData_XXX” to “OneDrive for Business” destination “UserName”.
• 10:31:20 AM : Uploading local “XXData_XXX202508111026.zip” to remote “XXData_XXX202508111026.zip” in folder “/Projects/Backups”.
• 10:48:53 AM : Uploaded 100.00 % (average speed = 1.21 MB/s).
• 10:48:53 AM : Verifying remote file “XXData_XXX202508111026.zip” with local one “XXData_XXX202508111026.zip”.
• 10:49:06 AM : Disconnecting from “OneDrive for Business” destination “UserName”.
• 10:49:06 AM : Cleaning up backups of "XXX weekly " job.
• 10:49:06 AM : Deleting temporary files.
• 10:49:06 AM : Job "XXX weekly " finished.