SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


These jobs are responsible for backup


These jobs are responsible for backup

Author
Message
forsqlserver
forsqlserver
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2546 Visits: 2050
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
Animal Magic
Animal Magic
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2090 Visits: 13737
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
Wilfred van Dijk
Wilfred van Dijk
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1644 Visits: 1363

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
Greg Charles
Greg Charles
SSCertifiable
SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)

Group: General Forum Members
Points: 6760 Visits: 5958
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search