Post reply

Hpw to Delete database from catalog

  • May 16, 2011 at 12:49 pm

    #238227

    Hello all,

    I have a really weird problem

    We have an schema whre we mount snapshots on a mountpoint in a c drive

    By mistake the the snapshot was deleted, so the database is no longer valid, I recreate the snapshot and mount it on the same mountpoint but the database is still unavailable

    The state of the db is Online, when I try to detach it it says that "Cannot detach a suspect or recovery pending database. It must be repaired or dropped", so i droped the db it seems to work, but the db remains in the catalog and reappears when you refresh the object explorer

    any ideas? i reallly need to remove it as soon as possible

    Thanks in advance

  • May 16, 2011 at 1:29 pm

    #1325427

    From a query, not the GUI

    DROP DATABASE <dbname>

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 16, 2011 at 1:38 pm

    #1325431

    Already tried that

    it says thant ended succesfully but the db is still there

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply