Re: delete database file on server -> sharing violation

From: Ed Murphy <emurphy42_at_socal.rr.com>
Date: Wed, 17 Oct 2007 14:34:54 -0700
Message-ID: <4716803d$0$16491$4c368faf@roadrunner.com>

pearl146_at_hotmail.com wrote:

> On Oct 17, 3:02 pm, Ed Murphy <emurph..._at_socal.rr.com> wrote:
>> pearl..._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).
> 
> Thanks Ed,
> but what do I need to do in Enterprise Manager? How can I delete the
> file from there?

Find the database on the left-hand side, generally like so:

   Console Root
   + Microsoft SQL Servers

     + SQL Server Group
       + (name of database server)
         + Databases
           + (name of database)

then right-click on the database -> All Tasks -> Detach Database

What is your company using SQL for? Is there anyone else there who is familiar with it? Received on Wed Oct 17 2007 - 16:34:54 CDT