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
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