Restored database in permanent loading state. Error 927.
Posted on 2004-12-01
I am restoring a database (dbOrig) as I have done many times before (create an empty database (dbTrain) & restore the backup copy (dbOrig) over the top of it). After just 10 or so seconds SQL Enterprise Manager reports that it has successfully completed the restore. Unfortunately the database icon is greyed out and word "loading" has appeared to the RHS of the database. When I access the database properties I get an error message "Error 927" stating that the database is still in the middle of a restore.
The database (dbOrig) is quite small so the restore should be quite fast. I have left the database for a few hours but without any luck.
I have taken the backup and restored it to another system without any difficulty. I have taken this backuo (dbOrig) and tried again on another empty database. The problem reappears.
I have researched the problem on the Web and there is quite a bit of material but few answers. A common suggestion is to run the command -
restore database <locked database name> with recovery
from Query Analyser. I have done so but I only get an error message -
"File 'mydata' was only partially restored by a database or file restore. The entire file must be successfully restored before applying the log.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally."
Any help would be gratefully appreciated. I have already spent considerable time on this (resarched Web, Microsoft, etc.).