We have limited space in a backup location so we have the bak set to auto delete every 1 day. The following error occurs every 48 hours after a backup. We are using v11.2. Any ideas of what could be causing the failure to delete the file on a regular basis?
Backup Job - 2 backup has failed
Summary (Failed)
Job: Backup Job - 2
Computer: XXXXXXXXXXXX
Date: 10/3/2017 9:00:01 PM
Backup type: Full
Backup archive size: 47.5GB
Database count: 2
MaConfig Full backup: Folder - success
HIL Full backup: Folder - success
Next backup: 2017-10-04 9:00:00 PM - Full
Detailed Log:
• 9:00:01 PM : Starting scheduled job “Backup Job - 2” with backup type “Full”. The computer name: “XXXXXXXXXXXXXXX”. The application version: “11.2.0”
• 9:00:01 PM : The backup folder of the job is “F:\Program Files\Temp\Pranas.NET\SQLBackupAndFTP\backup” with “68.883GB” free space. The temporary folder of the job is “F:\Program Files\Temp\Pranas.NET\SQLBackupAndFTP\backup” with “68.883GB” free space
• 9:00:01 PM : Backing up “.\MAXIMIZER” SQL Server databases
• 9:00:01 PM : Getting maximum file size…
• 9:00:01 PM : The maximum file size: “”
• 9:00:01 PM : Backing up “MaConfig” database to .bak file. Backup type: “Full”. Checksum: “Disabled”
• 9:00:02 PM : “MaConfig” database backup successfully completed. Backup type: “Full”
• 9:00:02 PM : Database “MaConfig” has been successfully backed up to “MaConfig201710032100.bak : 1.609MB”
• 9:00:02 PM : Backing up “HIL” database to .bak file. Backup type: “Full”. Checksum: “Disabled”
• 9:05:48 PM : “HIL” database backup successfully completed. Backup type: “Full”
• 9:05:48 PM : Database “HIL” has been successfully backed up to “HIL201710032100.bak : 47.452GB”
• 9:05:48 PM : Connecting to Folder destination “G:”
• 9:05:48 PM : Reading folder information by path: “G:”
• 9:05:49 PM : The current folder of the destination is “G:”
• 9:05:49 PM : Sending backup of “MaConfig” to Folder destination “G:”
• 9:05:57 PM : Uploading the local file “MaConfig201710032100.bak” into a remote file “MaConfig201710032100.bak”
• 9:05:57 PM : Uploaded 100 % (average speed = 51.5 MB/s)
• 9:05:57 PM : Verifying remote file “MaConfig201710032100.bak” with local one “MaConfig201710032100.bak”
• 9:05:57 PM : Sending backup of “HIL” to Folder destination “G:”
• 9:05:57 PM : Uploading the local file “HIL201710032100.bak” into a remote file “HIL201710032100.bak”
• 9:06:03 PM : Uploaded 100 % (average speed = 49 MB/s)
• 9:22:30 PM : Verifying remote file “HIL201710032100.bak” with local one “HIL201710032100.bak”
• 9:22:31 PM : Cleaning up backups of “Backup Job - 2” job
• 9:22:31 PM : Cleaning up backups of “MaConfig” database at Folder destination “G:”
• 9:22:31 PM : Cleaning up “G:” folder
• 9:22:31 PM : Deleting old backup of “MaConfig”. Backup type: “Full”. Backup time: “10/02/2017 21:06:06”. Files: “MaConfig201710022100.bak”
• 9:22:31 PM : Cleaning up backups of “HIL” database at Folder destination “G:”
• 9:22:31 PM : Cleaning up “G:” folder
• 9:22:31 PM : Deleting old backup of “HIL”. Backup type: “Full”. Backup time: “10/01/2017 21:22:20”. Files: “HIL201710012100.bak”
• 9:22:31 PM : Deleting old backup of “HIL”. Backup type: “Full”. Backup time: “10/02/2017 21:21:42”. Files: “HIL201710022100.bak”
• 9:22:31 PM : WARNING: Destination error: The process cannot access the file ‘G:\HIL201710022100.bak’ because it is being used by another process.
• 9:22:32 PM : WARNING: Destination error: The process cannot access the file ‘G:\HIL201710022100.bak’ because it is being used by another process.
• 9:22:32 PM : WARNING: Destination error: The process cannot access the file ‘G:\HIL201710022100.bak’ because it is being used by another process.
• 9:22:33 PM : WARNING: Destination error: The process cannot access the file ‘G:\HIL201710022100.bak’ because it is being used by another process.
• 9:22:34 PM : ERROR: Failed to clean up backups of “Backup Job - 2” job: [DST-1:1107#1] Failed to delete file “HIL201710022100.bak” > The process cannot access the file ‘G:\HIL201710022100.bak’ because it is being used by another process.
• 9:22:34 PM : Disconnecting from Folder destination “G:”
• 9:22:35 PM : ERROR: Job “Backup Job - 2” finished with “1” errors