Sunday, March 25, 2012

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.
TIAYeah!!!
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
>
>|||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
>>
>|||Actually, the biggest difference between delete and shift+delete is that
shift+delete
doesn't send files to the recycle bin.
"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
> >>
> >>
> >>
> >
> >
>

No comments:

Post a Comment