December 12, 2003 at 10:17 am
I'm trying to reload a copy of production to a test DB. It failed due to free disk space limits. Now the DB is stcuk in "Loading" status. Do I have to drop and recreate my database or is there an easier way to reset the status? sp_resetstatus didn't do the trick
Terry
Terry
December 12, 2003 at 11:46 am
Have you tried
RESTORE LOG [database name] WITH RECOVERY
December 18, 2003 at 6:57 pm
I've had this happen after cancelling a restore. To resolve it, I detach the offending database and then reattach it. I only do this after issuing a sp_who2. When this has happened in the past, the connection to the database doing the cancelled restore no longer exists. You won't be able to detach if you still have connections present.
November 13, 2006 at 10:31 am
I had the same problem when refreshing the Reporting database from Production database. In my shop, end-users run reports on Reporting database to reduce overhead on Production. Reporting database was in 'Loading' status because and I could not do a thing. So I had to detach database and attach it again. After that fix, DB got out of 'Loading' status and I was able to run the SQL job to refresh database. Ooff, what a relief!
November 15, 2006 at 1:55 pm
I had the same eperience. I had to drop the database and re-restore it.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply