|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
cannot drop mdf file
Hi All,
I cannot drop a mdf file that don't have a database but is in data directory,. Can you help-me ? I'am using sql server 2005. TIA Yeah!!!
shift+delete is the solution. Please ignore this!!! Show quoteHide quote "Roger" <roger@rnospam.com> escreveu na mensagem news:%23lOqzGHLIHA.4684@TK2MSFTNGP06.phx.gbl... > Hi All, > > > I cannot drop a mdf file that don't have a database but is in data > directory,. > > Can you help-me ? > I'am using sql server 2005. > > TIA > > > Shift + Delete would just delete the file without any warning\confirmation.
That's only the difference between Delete and Shift + Delete. File must be using by another process somehow when you were trying to delete the file and when you tried the Delete with Shift it was not being used so it was deleted I believe. -- Show quoteHide quoteEkrem Önsoy "Roger" <roger@rnospam.com> wrote in message news:%23dkmWQHLIHA.1188@TK2MSFTNGP04.phx.gbl... > Yeah!!! > > shift+delete is the solution. > > Please ignore this!!! > > > "Roger" <roger@rnospam.com> escreveu na mensagem > news:%23lOqzGHLIHA.4684@TK2MSFTNGP06.phx.gbl... >> Hi All, >> >> >> I cannot drop a mdf file that don't have a database but is in data >> directory,. >> >> Can you help-me ? >> I'am using sql server 2005. >> >> TIA >> >> >> > > Actually, the biggest difference between delete and shift+delete is that
shift+delete doesn't send files to the recycle bin. Show quoteHide quote "Ekrem Önsoy" wrote: > Shift + Delete would just delete the file without any warning\confirmation. > That's only the difference between Delete and Shift + Delete. > > File must be using by another process somehow when you were trying to delete > the file and when you tried the Delete with Shift it was not being used so > it was deleted I believe. > > -- > Ekrem Önsoy > > > > "Roger" <roger@rnospam.com> wrote in message > news:%23dkmWQHLIHA.1188@TK2MSFTNGP04.phx.gbl... > > Yeah!!! > > > > shift+delete is the solution. > > > > Please ignore this!!! > > > > > > "Roger" <roger@rnospam.com> escreveu na mensagem > > news:%23lOqzGHLIHA.4684@TK2MSFTNGP06.phx.gbl... > >> Hi All, > >> > >> > >> I cannot drop a mdf file that don't have a database but is in data > >> directory,. > >> > >> Can you help-me ? > >> I'am using sql server 2005. > >> > >> TIA > >> > >> > >> > > > > > >
Other interesting topics
Performance of SQL Server Express
copy many ssis packages between servers BOL - Katmai CPU dedicated to one Stored Procedure Linked Server Properties - Security - SQL Server 2000 Backing up to a server on another domain ? Stranger than Fiction: differences in Edit vs Design a view rollback in trigger Cannot delete a maintenance plan Telling a user of an error in a function |
|||||||||||||||||||||||