Posted by Ed Murphy on 10/17/07 21:34

pearl146@hotmail.com wrote:

> 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?

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?

[Back to original message]