I have seen another very common backup job failed error, when we check backup files generates successfully but job fails with following error
Alert description: BackupDiskFile::CreateMedia: Backup device ‘xxx.bak’ failed to create. Operating system error 32(The process cannot access the file because it is being used by another process.).
You could see that job is failed due to file is in use, generally we creates backup maintenance plan to take backup and after backup completes successfully we also include the maintenance cleanup task, which maintains the retention period of old backup files to keep our Drive space free.
- For corporate companies they have a standard practice to keep backup of the database backup files upto 30 days to 90days just for safety and per DR process for that they use build in system or third party tool like VERITAS Net Backup.
- Sometimes “Antivirus “ application also scans backup files which holds the file could cause this issue.
Note: Should exclude database files for these scans.
So sometimes when our cleanup task runs during that time netbackup or other application holding this backup file, due to that our backup job fails at cleaning up task with given error.
Resolution:
>> Re-Schedule the net-backup or our maintenance plan task to run at different time.
>> Exclude the antivirus scan for database files and backup files.
Vinay Thakur 