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’.