SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Need help - SQL Backup Jobs Failing
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

agastyamahi
Starting Member

Canada
33 Posts

Posted - 11/19/2013 :  16:44:50  Show Profile  Reply with Quote
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

USA
37466 Posts

Posted - 11/19/2013 :  16:53:05  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

agastyamahi
Starting Member

Canada
33 Posts

Posted - 11/19/2013 :  18:12:50  Show Profile  Reply with Quote
Thanks for your response, our organization is doing the backups that way.

Is there any other way other than downloading the process explorer.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37466 Posts

Posted - 11/19/2013 :  18:15:13  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.28 seconds. Powered By: Snitz Forums 2000