Posted by pearl146 on 10/17/07 21:31

On Oct 17, 5:05 pm, bdbafh <bdb...@gmail.com> wrote:
> pearl...@hotmail.com wrote:
> > Hi,
>
> > I have some database files (.MDF, .LDF,...) on the server. When I try
> > to delete them, the warning "Cannot delete file: There has been a
> > sharing violation. The source or destination file may be in use."
> > appears.
>
> > Since I am new to the environment I don't know where the files come
> > from and where they might be used.
>
> > Can anybody tell me what to do to delete those files?
>
> > Thank you.
>
> If you were running on Linux, the operating system would dutifully
> obey your command.
> The files would remain accessible to existing processes which already
> had handles.
> After the last handle on the file(s) has been released, the file(s)
> would no longer exist.
>
> Be glad that the OS that you are using has training wheels.
>
> There are utilities from SysInternals (since acquired by Microsoft)
> for locating processes holding handles on files. Handle.exe would be
> one, process monitor is another.
>
> try here:http://www.microsoft.com/technet/sysinternals/default.mspxhttp://www.microsoft.com/technet/sysinternals/Processesandthreadsutil...
>
> You have backups of the databases of interest on this server, right?
>
> hth.
>
> -bdbafh

I don't know if there are backups.

Thanks, I will try Handle.exe.

[Back to original message]