Re: delete database file on server -> sharing violation

From: Ed Murphy <emurphy42_at_socal.rr.com>
Date: Wed, 17 Oct 2007 12:02:19 -0700
Message-ID: <47165c65$0$20637$4c368faf@roadrunner.com>

pearl146_at_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). Received on Wed Oct 17 2007 - 14:02:19 CDT