Re: Droping a database after detached it.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: SangHunJung (SangHunJung_at_discussions.microsoft.com)
Date: 10/04/04 

Date: Mon, 4 Oct 2004 07:29:09 -0700

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.)
>
>
>

Relevant Pages

  • Re: Attaching files question
    ... pattern - sometimes the numbers are in some sort of order...in reverse ... I get the numbers in sequence but still in reverse ... >attach one at a time and do a File | Save in between for each attachment. ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: msdb restore?
    ... attach as a different database name. ... and you may be S.O.L. (this is what backups are ... >> (Reverse address to reply.) ... >>> the master, msdb, etc was deleted. ...
    (microsoft.public.sqlserver.server)
  • Re: Procedures
    ... Okay: ... SET @in = 'Andrew' ... EXEC dbo.foo @in, @out OUTPUT ... (Reverse address to reply.) ...
    (microsoft.public.sqlserver.programming)
  • Re: powered by Ruby icon?
    ... > I think it is okay to attach such a tiny file so here it is. ... another "powered" in the badge strip. ... > the environment and saving oil and other rare ressources is a matter ...
    (comp.lang.ruby)
  • Powerhead for prefiltered reverse-flow undergravel filter
    ... What brands and models of powerheads work in reverse and are easy to ... attach a filter to? ... Thank you in advance for all replies. ...
    (rec.aquaria.freshwater.misc)