October 8, 2009 at 6:50 am
My jobs are failing with this message:
Cannot open backup device 'S:\BackupFolder\Dashboard'. Operating system error 32(The process cannot access the file because it is being used by another process.)
These jobs are responsible for backup.
Thanks
October 8, 2009 at 6:59 am
i am assuming that S:\ is a mapped drive. normal culprit for these errors is that the account under which the sql agent service is running does not have that drive mapped or does not have permissions to the drive
You have two options
1) Log in as the service user and make sure you can create files in the s:\ location which the backups are going into.
2) Change the S:\ to the actual UNC path of the backup directory (if you have a permissions issue with S:\ you will still have the permissions error with this)
John
October 8, 2009 at 7:01 am
Operating system error 32(The process cannot access the file because it is being used by another process.)
As reported, something else is locking this file. Maybe a filebackup is running at the same time?
You could use filemon (for example) to see what's locking this file.
Wilfred
The best things in life are the simple things
October 8, 2009 at 2:26 pm
I see this error occasionally when the tape copy is running a little longer than normal and has the backup file open when a backup job runs. We've alleviated the problem by specifying multiple step retry attempts in the backup jobs so when a file is in use, the job will wait a specified length of time then retry.
Greg
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply