Restore left DB in Loading state, need to get rid of DB

• Jim Kjeer

  Grasshopper

  Points: 14

  More actions

  February 3, 2006 at 2:49 pm

  #116134

  When trying to restore a DB the operation failed.  It says "Loading", and I can't do anything with it.  I no longer need the DB at all, how can I get rid of it?

• David.Poole

  SSC Guru

  Points: 76001

  More actions

  February 4, 2006 at 4:02 am

  #618841

  I don't have BOL in front of me but look for a procedure with a name like sp_resetstatus.

  Once you have done that you should be able to DROP the database.

  LinkedIn Profile