November 21, 2010 at 6:54 pm
Dear Experts,
In the production server we have a scheduled job to take a backup which runs every week end 12:00PM.Untill now it was working fine without any issues.
Suddenly yesterday it got failed by throwing following error:
Executed as user: <username>. Cannot open backup device 'E:\LOCAL\database\Backup\ARMY Full Backup Sunday.BAK'. Operating system error 32(error not found). [SQLSTATE 42000] (Error 3201) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
Could you please help to get through this error.
Thanks in adavance,
Gangadhar
November 21, 2010 at 7:25 pm
Does the file exist in specified location?
Are you able to access the file?
Vishal Gajjar
http://SqlAndMe.com
November 21, 2010 at 8:53 pm
Operating System Error 32 means "The process cannot access the file because it is being used by another process." Please check if any process like Antivirus or the Tape backup process is using that file. You may use Process Explorer to check which process is using that file. Here[/url] is an example.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
November 22, 2010 at 2:12 am
...else it could be running under compressed folder....
November 22, 2010 at 10:56 am
The error is stating that the file is in use by another application. If I were to fathom a guess, I would say take a look at your virus scan as the culprit.
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
June 25, 2014 at 9:57 am
Vishal.Gajjar (11/21/2010)
Does the file exist in specified location?Are you able to access the file?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply