Prevent the "System" process from locking my files in a shared folder.

Posted by Kamarey on Server Fault See other posts from Server Fault or by Kamarey
Published on 2011-06-28T15:26:01Z Indexed on 2011/06/28 16:24 UTC
Read the original article Hit count: 216

Filed under:
|
|
|

I have an application that creates files to be processed by SQL bulk. The files are created in shared folder on another server and than taken from there by SQL.

The problem that sometime SQL returns an error, that the file is locked by another process and can't be accessed. The process that locks these files is "System" process.

Looks like it lock files because of they are in a shared folder, but not sure.

The use of any software to unlock files manually is not an option, as all bulk process is automatic.

The question is: Why the "System" process locks these files and is there a way to prevent this?

© Server Fault or respective owner

Related posts about file

Related posts about process