I have a job that takes backup of all the databases every day and puts it in the device for that day (Eg all backups taken on Sunday will be in the device named Sunday).
Sometimes, some of the database backups are failing with the error message below.
Cannot open backup device 'Monday(\\devsql.Monday.bak)'. Operating system error 32(The process cannot access the file because it is being used by another process.). [SQLSTATE 42000] (Error 3201) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
I checked if any other process was running at the same time. But there was no such process.
Could you please help me figure out why these jobs are failing