Droping a database after detached it.

I have detached a CBA database about a week ago and it seems like we donâ't
need it any more.
Now, I want to clean my system and ran drop database and it said â'Cannot
drop the database 'CBAâ', because it does not exist in the system catalog.â'
Is that mean I can simply delete the mdf and ldf physical files?
Thanks in advance.
SanghunYes, you can delete the files... If the database is detached, the server no
longer has any knowledge of it.
However, I would highly recommend backing them up first. You never know...
"SangHunJung" <SangHunJung@.discussions.microsoft.com> wrote in message
news:91C87395-8094-45D5-8A1F-5A74BE53AF74@.microsoft.com...
> I have detached a CBA database about a week ago and it seems like we don't
> need it any more.
> Now, I want to clean my system and ran drop database and it said "Cannot
> drop the database 'CBA', because it does not exist in the system catalog."
> Is that mean I can simply delete the mdf and ldf physical files?
> Thanks in advance.
> Sanghun
>|||> Now, I want to clean my system and ran drop database and it said â'Cannot
> drop the database 'CBAâ', because it does not exist in the system
catalog.â'
> Is that mean I can simply delete the mdf and ldf physical files?
Yes. However if you want to remove all backup history etc., I would
re-attach it and then drop it.
--
http://www.aspfaq.com/
(Reverse address to reply.)|||I see, that is what I wanted to do. I renamed to _old before I detached it
so it should be okay to attach again and drop it.
Thank you both of you!
Sunny
"Aaron [SQL Server MVP]" wrote:
> > Now, I want to clean my system and ran drop database and it said ââ?¬Å?Cannot
> > drop the database 'CBA�, because it does not exist in the system
> catalog.�
> > Is that mean I can simply delete the mdf and ldf physical files?
> Yes. However if you want to remove all backup history etc., I would
> re-attach it and then drop it.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>