Restored database in permanent loading state. Error 927.

Posted on 2004-12-01
Last Modified: 2012-06-21

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.).


Question by:HelpPilgrimSystems
    LVL 6

    Expert Comment

    Hi Dave,


    That is a corrupted db, I also experienced this before, try to restore it again. Then to get rid of the corrupted one, try to detach it.

    good luck

    LVL 18

    Accepted Solution

    - Delete the database in Enterprise Manager
    - Go to the data folder and delete any MDFs that look applicable to the database
    - Go to the log folder and delete any LDFs that look applicable to the database
    - Reapply SP3 for SQL Server (on the server and especially -- if applicable -- the workstation you are restoring on)
    - Try again.

    Especially the second and third step sometimes do the trick. Ensure the file paths and names are correct (in the options tab while restoring).

    Author Comment

    Thank you both for your comments.

    I had already tried as Wim suggested. I had also tried the first foiur steps suggested by SjoerdVerweij. I have not yet tried to reapply SP3 for SQL Server. I shall do so and advise you when done.

    Thank you,


    Author Comment

    The reinstallation of SQL Server SP3a worked!!! I have been looking for a solution to this for a while. I had problems installing SP 3a though. It experienced errors running the first sql script. I tried the restore again despite problems with SP3a. It worked. Thank you!!


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now