Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
agastyamahi
Starting Member
33 Posts |
 Posted - 2013-11-19 : 16:44:50
|
| Hi,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 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-11-19 : 16:53:05
|
| On my systems, it's usually because of the tape backup software sweeping the file to tape.Why do you put multiples file in one backup device though? The industry standard is not to use backup devices and all backups get their own files.You can use Process Explorer to see what is accessing it. You'll need to download it.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
agastyamahi
Starting Member
33 Posts |
Posted - 2013-11-19 : 18:12:50
|
| Thanks for your response, our organization is doing the backups that way. Is there any other way other than downloading the process explorer. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-11-19 : 18:15:13
|
| Process Explorer is free. You could stop the tape software service to see if that releases the file or find the process in Task Manager to kill it.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Need help - SQL Backup Jobs Failing