April 8, 2008 at 4:40 am
My I have scheduled SQL db of the 64 gb to backup locally but fails when reaching a certain point with this Error: Operating system error33(The process cannot access the file because another process has locked a portion of the file).
My problem I cannot pinpoint which process is keeping on locking the file
Pls help
Thanks
April 8, 2008 at 6:17 am
Can you post the T-SQL used to backup the DB? Right now, I don't think we have enough info to pinpoint the answer.
-- Cory
April 8, 2008 at 12:14 pm
Could it be anything with antivirus or backup software that is locking the file?
Ola Hallengren
April 8, 2008 at 8:40 pm
You may use Sysinternals Suite to find out which process is holding the backup file. Take a look handle or Process Explorer.
http://technet.microsoft.com/en-us/sysinternals/0e18b180-9b7a-4c49-8120-c47c5a693683.aspx
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply