MSSQL jobs have sporadic database failures with 'Failed to execute "sp_dropdevice"'

I’m having trouble getting complete backups of all databases because of occasional error pairs like the one pasted below. I’m running backup copy jobs locally on the MSSQL server.

My assumption is that the backup has a conflict with some other running process, but I would have thought that a backup copy job could coexist with other things.

In this job from last night, only one database failed to back up – the rest were successful.

12/10/2023 9:08:21 PM	[Info]	Starting scheduled job "Backup Job - Client " - "Full Copy". Server "SQL01". System account "xxxx@contoso". App v."12.7.19".
12/10/2023 9:08:21 PM	[Info]	Connecting to "SQL Server": ".\Client".
12/10/2023 9:08:21 PM	[Info]	Connected to "SQL RTM Standard Edition (64-bit)".
12/10/2023 9:08:22 PM	[Info]	The temporary folder "I:\SQLBackupandFTP\Pranas.NET\SBF\ac677b63-79c1-48c1-ab49-c7a752afc6c4\backup" has "44.738GB" free space.
12/10/2023 9:08:22 PM	[Info]	Backing up ".\Client" SQL Server databases.
12/10/2023 9:08:22 PM	[Info]	The maximum file size for destination "Backblaze B2: SQL01-backup": "10TB".

12/10/2023 9:25:36 PM [Error] Failed to backup “Client_33_642_Final_Completes_Refields” database with “FullCopy” backup type: Failed to execute “sp_dropdevice” SQL procedure. > Could not delete the physical file ‘I:\SQLBackupandFTP\PranasNET\SBF\ac677b63-79c1-48c1-ab49-c7a752afc6c4\backup\Client_33_642_Final_Completes_Refields202312102125fullcopy.bak’. The DeleteFile system function returned error 32(The process cannot access the file because it is being used by another process.).

12/10/2023 10:17:47 PM [Error] Destination error: Failed to upload “I:\SQLBackupandFTP\PranasNET\SBF\ac677b63-79c1-48c1-ab49-c7a752afc6c4\backup\Client_33_642_Final_Completes_Refields202312102125fullcopy.7z” file to “” folder. > Could not find file ‘I:\SQLBackupandFTP\PranasNET\SBF\ac677b63-79c1-48c1-ab49-c7a752afc6c4\backup\Client_33_642_Final_Completes_Refields202312102125fullcopy.7z’.

Hello Joe_Stern,

To investigate this case, we require more details. Could you please provide the Advanced Log by following the instructions at How to send Log to developers | SQLBackupAndFTP's blog?

Once the log has been sent, please notify us and provide your App ID (“Help” > “About”).

Additionally, please inform us how frequently you encounter this issue.

Feel free to reach out if you have any further questions.

Thank you, and we apologize for the inconvenience.