Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 DB in a suspended state of restoring

Author  Topic 

10Dawg
Starting Member

46 Posts

Posted - 2011-12-13 : 10:25:48
I tried to load a 2005 database into 2008 SSMS. Now it is in a suspended state of "restoring". The detaching option is low lighted and the "offline" option throws an error "Cannot detach while restoring". I just want this thing off my machine. HELP!!!

10Dawg

Kristen
Test

22859 Posts

Posted - 2011-12-13 : 11:54:50
DROP it rather than DETACHing it ?
Go to Top of Page

10Dawg
Starting Member

46 Posts

Posted - 2011-12-13 : 12:06:22
BOOM! Gone! Thanks Kristen

10Dawg
Go to Top of Page
   

- Advertisement -