Posted by Ed Murphy on 10/17/07 19:02

pearl146@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).

[Back to original message]