October 14, 2008 at 10:00 pm
Hi friends,
The backup job which is running fine from past six months suddenly started failing giving the following error:
Message
Executed as user:. Write on "Location" failed: 33(The process cannot access the file because another process has locked a portion of the file.) [SQLSTATE 42000] (Error 3202) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
The error says portion of file has been locked. I have check all SQL logs nothing was there, I checked and found there are no LOCKS as well. Even I tried running the job after sometime but no luck 🙁 .
The job was failing form last 3 days I'm unable to find the reason.
Can anyone help me in fixing this issue ASAP.
October 15, 2008 at 2:49 am
I'm not able to backup manually also.
Can't restart as its a production server.
October 15, 2008 at 3:09 am
As I mentioned above I have checked the current activities and didn't find any processes using that file.Even Task manager also didn't help.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply