Post reply

Database with a Loading Status (Server Rebooted during Restore)

  • October 28, 2004 at 1:14 pm

    #162536

    I was in the middle of a Database Restore Operation on our SQL Server (2000, SP 3) when another DBA accidently rebooted the Server. When the Server completed the reboot process, I logged in and went into EM. The Database which was being restored does not show any properties and it is showing a 'Loading' Status. Do I just need to wait it out and see if the Restore Operation is continuing and if it will complete.

    Thanks in advance, Kevin

     

  • October 28, 2004 at 1:20 pm

    #528339

    I'm lazy so i've just copied from BOL but you want to do the following basically specify your restore operation with restart.

    C. Restore a database using RESTART syntax

    This example uses the RESTART option to restart a RESTORE operation interrupted by a server power failure.

    -- This database RESTORE halted prematurely due to power failure.

    RESTORE DATABASE MyNwind

    FROM MyNwind_1

    -- Here is the RESTORE RESTART operation.

    RESTORE DATABASE MyNwind

    FROM MyNwind_1 WITH RESTART

    hth

    Dave

  • October 29, 2004 at 6:35 am

    #528383

    I am restoring from Disk. In BOL under the Restore Command Subject states:

    RESTART

    Specifies that SQL Server should restart a restore operation that has been interrupted. RESTART restarts the restore operation at the point it was interrupted.

    Important  This option can only be used for restores directed from tape media and for restores that span multiple tape volumes.

     

     

  • October 29, 2004 at 6:55 am

    #528387

    Did you do a sp_who or look at the Process Info?  Is the restore thread there?  I would guess that there is no active thread for the restore.  I would think you would need to drop the database that is stuck in loading mode and restore it again.

  • October 29, 2004 at 7:13 am

    #528391

    If I were you, I would drop the database and restore it again

  • October 29, 2004 at 8:02 am

    #528401

    1) tell the other dba(s) you're going to redo the restore

                so (s)he doesn't  redo the reboot

    2) redo the (full/pit) restore ! No need to drop the db first.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply