Posted by pearl146 on 10/17/07 20:18

On Oct 17, 3:02 pm, Ed Murphy <emurph...@socal.rr.com> wrote:
> pearl...@hotmail.com wrote:
> > 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?
>
> Assuming this is MS SQL (I don't know what extensions Oracle uses), you
> need to detach the database from SQL. Can be done via GUI or CHUI. For
> a GUI, use Enterprise Manager (SQL 2000) or Management Studio (2005).

Thanks Ed,
but what do I need to do in Enterprise Manager? How can I delete the
file from there?

[Back to original message]