Trying to setup the backup to OneDrive for Business, the connection tested successfully to the OneDrive folder and it does start to upload and then fails. Below is the log. Any help would be appreciated.
Detailed Log:
- 10:37:39 AM : Starting job "Backup Job - 1 " - “Full”. Server “SERVERNAME”. Account “administrator@DOMAIN NAME”. App v.“12.3.8”.
- 10:37:39 AM : Connecting to SQL Server: 2016 SP2 Enterprise Edition (64-bit). .\CASHLESSCATERING
- 10:37:40 AM : The backup folder “C:\Program Files\Microsoft SQL Server\MSSQL13.CASHLESSCATERING\MSSQL\Backup” has “176.31GB” free space. The temporary folder “C:\Users\administrator.DOMAIN\AppData\Local\Temp\Pranas.NET\SQLBackupAndFTP\backup” has “176.31GB” free space
- 10:37:40 AM : Backing up “.\CASHLESSCATERING” SQL Server databases
- 10:37:40 AM : The maximum file size for destination “OneDrive for Business: SQL and FTP Backup”: “10GB”
- 10:37:40 AM : Backing up “CashlessCatering” database to .bak file. Backup type: “Full”. Checksum: “Disabled”.
- 10:37:41 AM : “CashlessCatering” database backup successfully completed. Backup type: “Full”.
- 10:37:41 AM : Database “CashlessCatering” successfully backed up to “C:\Program Files\Microsoft SQL Server\MSSQL13.CASHLESSCATERING\MSSQL\Backup\CashlessCatering202002171037.bak : 158.109MB”
- 10:37:41 AM : Compressing “C:\Program Files\Microsoft SQL Server\MSSQL13.CASHLESSCATERING\MSSQL\Backup\CashlessCatering202002171037.bak” file with Internal archiver. Encryption: “Off”
- 10:38:05 AM : Backup of “CashlessCatering” successfully compressed to “(CashlessCatering202002171037.zip : 130.943MB)”
- 10:38:06 AM : Connecting to “OneDrive for Business” destination “SQL and FTP Backup”
- 10:38:06 AM : Creating folder “/Vericool”
- 10:39:46 AM : WARNING: Destination error: One or more errors occurred. > Code: timeout Message: The request timed out. > A task was canceled. > Code: timeout Message: The request timed out. > A task was canceled.
- 10:39:46 AM : Trying again…
- 10:41:26 AM : WARNING: Destination error: One or more errors occurred. > Code: timeout Message: The request timed out. > A task was canceled. > Code: timeout Message: The request timed out. > A task was canceled.
- 10:41:26 AM : Trying again…
- 10:41:27 AM : The current destination folder is “/Vericool”
- 10:41:28 AM : Sending backup of “CashlessCatering” to “OneDrive for Business” destination “SQL and FTP Backup”
- 10:41:28 AM : Uploading local “CashlessCatering202002171037.zip” to remote “CashlessCatering202002171037.zip” in folder “/Vericool”
- 10:43:08 AM : WARNING: Destination error: One or more errors occurred. > Code: timeout Message: The request timed out. > A task was canceled. > Code: timeout Message: The request timed out. > A task was canceled.
- 10:43:08 AM : Trying again…
- 10:54:18 AM : Uploaded 6.2 % (average speed = 10.8 KB/s)
- 10:46:13 AM : WARNING: Destination error: One or more errors occurred. > Code: tooManyRetries Message: More than 3 retries encountered while sending the request.
- 10:46:13 AM : Trying again…
- 10:47:54 AM : WARNING: Destination error: One or more errors occurred. > Code: timeout Message: The request timed out. > A task was canceled. > Code: timeout Message: The request timed out. > A task was canceled.
- 10:47:54 AM : Trying again…
- 10:54:29 AM : Cancelling job "Backup Job - 1 "
- 10:55:15 AM : ERROR: Destination error: The operation was canceled.
- 10:55:16 AM : Disconnecting from “OneDrive for Business” destination “SQL and FTP Backup”
- 10:55:16 AM : ERROR: Job cancelled. Job cancelled by user
- 10:55:17 AM : ERROR: Job "Backup Job - 1 " finished with “2” errors