Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: delete database file on server -> sharing violation

Re: delete database file on server -> sharing violation

From: <pearl146_at_hotmail.com>
Date: Wed, 17 Oct 2007 13:18:04 -0700
Message-ID: <1192652284.313544.161770@t8g2000prg.googlegroups.com>


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? Received on Wed Oct 17 2007 - 15:18:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US