You are here: Re: delete database file on server -> sharing violation « MsSQL Server « IT news, forums, messages
Re: delete database file on server -> sharing violation

Posted by pearl146 on 10/17/07 20:18

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?

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация