This question seems to pop up a couple of times a year. Below is my response from the last time it appeared...

I had a similar issue with a database that I was restoring and found a
reference on MSDN to possible workaround. Try using RESTORE DATABASE
[DatabaseName] WITH RECOVERY. This basically tells SQL Server to override
the LOADING status and complete the recovery process.

For more info, see KB article 272683.
http://support.microsoft.com/default.aspx?scid=kb;en-us;272683

Hope this helps.
Kevin Martin
Database Engineer
Multimedia Games



-----Original Message-----
From: Long, Darlene M [mailto:[Email Address Removed] Thursday, April 29, 2004 10:33 AM
To: LazyDBA.com Discussion
Subject: Question: Loading state for restore of database


This morning I was trying to restore a backup copy of our production
environment to our test environment when the network had a hiccup. This has
left my test database in a 'loading' state. I don't need the existing
database since it is a test database, but I can't even delete it. When
running sp_helpdb, it does not show up in the list of databases, although I
can see it in enterprise manager. Also, it says that it is not part of the
data collection.

I know there is a way to remove this database, but for the life of me I
can't remember.

Would you please pass on any suggestions?

Thanks in advance,

Darlene

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.672 / Virus Database: 434 - Release Date: 4/28/2004


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.672 / Virus Database: 434 - Release Date: 4/28/2004

MS Sql Server LazyDBA home page