Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

These jobs are responsible for backup Expand / Collapse
Author
Message
Posted Thursday, October 8, 2009 6:50 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, December 4, 2014 7:30 AM
Points: 1,202, Visits: 1,946


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

Post #799947
Posted Thursday, October 8, 2009 6:59 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, December 15, 2014 4:34 AM
Points: 1,001, Visits: 13,533
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
Post #799957
Posted Thursday, October 8, 2009 7:01 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Saturday, December 6, 2014 5:36 AM
Points: 938, Visits: 1,159

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
Post #799960
Posted Thursday, October 8, 2009 2:26 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, December 15, 2014 12:03 PM
Points: 4,064, Visits: 5,372
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
Post #800354
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse