open files

  • Thread starter Thread starter Andre
  • Start date Start date
A

Andre

Win2k sp4, all security updates.

Is there any way I can troubleshoot what is causing files to remain open? I
have a situation where I backup my sql db from Server1 to Server2. Part of
the backup process is to delete old files. About a month ago, I started
having issues with the backup job where it would fail because it couldn't
delete an old file. The problem is that on Server2, the file is 'open'. If
I clear the open file(s), the backup successfully completes because it's
able to both backup and delete old files.

I'm half suspecting this issue started after I applied a security update (or
perhaps even sp4), but I can't confirm that. Any insight is appreciated.

Thanks, Andre
 
You can turn on auditing and see what program is accessing the file.
Sysinternals.com has some great tools (like Handle v2.1) that might help you
with what you're looking to do.

301640 HOW TO: Set, View, Change, or Remove Auditing for a File or Folder in
http://support.microsoft.com/?id=301640

http://www.sysinternals.com/
--
--
Daniel Chang
Server Setup Team

Search our Knowledge Base at http://support.microsoft.com/directory
Visit the Windows 2000 Homepage at
http://www.microsoft.com/windows2000/default.asp
See the Windows NT Homepage at http://www.microsoft.com/ntserver/

NOTE: Please reply to the newsgroup and not directly to me. This allows
others to add to and benefit from these threads and also helps to ensure a
more timely response. Thank you!
This posting is provided "AS IS" without warranty either expressed or
implied, including, but not limited to, the implied warranties of
merchantability or fitness for a particular purpose.
The views and opinions expressed in this newsgroup posting are mine and do
not necessarily express or reflect the views and / or opinions of Microsoft.


: Win2k sp4, all security updates.
:
: Is there any way I can troubleshoot what is causing files to remain open?
I
: have a situation where I backup my sql db from Server1 to Server2. Part
of
: the backup process is to delete old files. About a month ago, I started
: having issues with the backup job where it would fail because it couldn't
: delete an old file. The problem is that on Server2, the file is 'open'.
If
: I clear the open file(s), the backup successfully completes because it's
: able to both backup and delete old files.
:
: I'm half suspecting this issue started after I applied a security update
(or
: perhaps even sp4), but I can't confirm that. Any insight is appreciated.
:
: Thanks, Andre
:
:
 
Back
Top