Backups failure (Destination error: Failed to retrieve remote file information)


#1

Backups fail about 50% of the time with error Backups failure (Destination error: Failed to retrieve remote file information)

11/26/2018 2:00 AM Starting scheduled job "Protech_Online " - “Full”. Computer “PTS4”. App v.“12.0.4”
11/26/2018 2:00 AM Connecting to SQL Server: 2017 RTM Express Edition (64-bit). pts4\paradigm
11/26/2018 2:00 AM The backup folder “C:\Program Files\Microsoft SQL Server\MSSQL14.PARADIGM\MSSQL\Backup” has “62.397GB” free space. The temporary folder “C:\Windows\TEMP\SYSTEM\Pranas.NET\SQLBackupAndFTP\backup” has “62.397GB” free space
11/26/2018 2:00 AM Backing up “pts4\paradigm” SQL Server databases
11/26/2018 2:00 AM Getting maximum file size…
11/26/2018 2:00 AM The maximum file size: “10240.000GB”
11/26/2018 2:00 AM Backing up “ProTech” database to .bak file. Backup type: “Full”. Checksum: “Disabled”
11/26/2018 2:01 AM “ProTech” database backup successfully completed. Backup type: “Full”
11/26/2018 2:01 AM Database “ProTech” successfully backed up to “ProTech201811260200.bak : 561.922MB”
11/26/2018 2:01 AM Compressing “ProTech201811260200.bak” file with Internal archiver. Encryption: “Off”
11/26/2018 2:02 AM Backup of “ProTech” successfully compressed to “(ProTech201811260200.zip : 71.006MB)”
11/26/2018 2:02 AM Backing up “ProTech_FS” database to .bak file. Backup type: “Full”. Checksum: “Disabled”
11/26/2018 2:13 AM “ProTech_FS” database backup successfully completed. Backup type: “Full”
11/26/2018 2:13 AM Database “ProTech_FS” successfully backed up to “ProTech_FS201811260202.bak : 2.199GB”
11/26/2018 2:13 AM Compressing “ProTech_FS201811260202.bak” file with Internal archiver. Encryption: “Off”
11/26/2018 2:16 AM Backup of “ProTech_FS” successfully compressed to “(ProTech_FS201811260202.zip : 1.589GB)”
11/26/2018 2:16 AM Connecting to Backblaze B2 destination “Protech2”
11/26/2018 2:16 AM The current destination folder is “”
11/26/2018 2:16 AM Sending backup of “ProTech” to Backblaze B2 destination “Protech2”
11/26/2018 2:16 AM Uploading local “ProTech201811260200.zip” to remote “ProTech201811260200.zip” in folder “”
11/26/2018 2:17 AM Uploaded 100 % (average speed = 1.4 MB/s)
11/26/2018 2:17 AM Verifying remote file “ProTech201811260200.zip” with local one “ProTech201811260200.zip”
11/26/2018 2:17 AM Disconnecting from Backblaze B2 destination “Protech2”
11/26/2018 2:17 AM Connecting to Backblaze B2 destination “Protech2”
11/26/2018 2:17 AM The current destination folder is “”
11/26/2018 2:17 AM Sending backup of “ProTech_FS” to Backblaze B2 destination “Protech2”
11/26/2018 2:17 AM Uploading local “ProTech_FS201811260202.zip” to remote “ProTech_FS201811260202.zip” in folder “”
11/26/2018 2:17 AM Uploaded 100 % (average speed = 312.8 MB/s)
11/26/2018 2:17 AM Destination error: Failed to retrieve remote file information (null). File name: “ProTech_FS201811260202.zip”. Folder path: “”.
11/26/2018 2:17 AM Disconnecting from Backblaze B2 destination “Protech2”
11/26/2018 2:17 AM Cleaning up backups of "Protech_Online " job
11/26/2018 2:17 AM Cleaning up backups of “ProTech” database at Backblaze B2 destination “Protech2”
11/26/2018 2:17 AM Cleaning up “” folder
11/26/2018 2:17 AM Deleting old backup of “ProTech”. Backup type: “Full”. Backup time: “11/11/2018 02:19:53”. Files: “ProTech201811110200.zip”
11/26/2018 2:17 AM Destination error: One or more errors occurred. > Backblaze B2 Error. Code: not_found (file_state_none)
11/26/2018 2:17 AM Destination error: One or more errors occurred. > Backblaze B2 Error. Code: not_found (file_state_none)
11/26/2018 2:17 AM Destination error: One or more errors occurred. > Backblaze B2 Error. Code: not_found (file_state_none)
11/26/2018 2:18 AM Destination error: One or more errors occurred. > Backblaze B2 Error. Code: not_found (file_state_none)
11/26/2018 2:18 AM Failed to clean up backups of "Protech_Online " job: [DST-10:1104#1] Failed to get metadata of “4_zfa352cde64beab8a6c4c0319_f2009363d4715d0fb_d20181111_m091800_c001_v0001006_t0005” file on “” folder. > One or more errors occurred. > Backblaze B2 Error. Code: not_found (file_state_none)
11/26/2018 2:18 AM ProTech201811110200.zip not found on the destination.
11/26/2018 2:18 AM Found “24” backups of “ProTech”. Old backups: “2”
11/26/2018 2:18 AM Deleting old backup of “ProTech”. Backup type: “Full”. Backup time: “11/12/2018 02:00:00”
11/26/2018 2:18 AM Deleting old backup of “ProTech_FS”. Backup type: “Full”. Backup time: “11/12/2018 02:03:00”
11/26/2018 2:18 AM Job "Protech_Online " finished with “1” errors
11/26/2018 2:18 AM Sending job log to elvin@cecdirect.com


#2

Hi Kevin,

Thanks for the issue reporting. To investigate this case we need more details. Could you please send us your advanced log. Please find more details on how to do it at https://sqlbackupandftp.com/blog/how-to-send-log-to-developers

Please let us know when the logs will be sent.

Sorry for the inconvenience.