Post reply

Restore Fails -- But DB says it is Loading

  • November 10, 2004 at 7:50 am

    #108952

    Hi

    I am kind of new to Restores and Backups

    Let me explain what we do.  We back up the Production and make a copy of the backup and Restore it for Marketing Analysis etc. etc.

    Step 1) --> We kill all active processes

    Step 2) --> Move from Prod Backup to E drive of the QA server. 

     

     

    Now Step 2 Failed because there is not enough DISK Space for the data file.  Understand that, but this leaves the DB on QA server on "Loading" mode.  It doesnt go back to "regular" mode, so that it can be used.  

    Can somebody explain what should I do , so that next time if the Restore Fails -- then I should be able to use the DB.

     

    Thanks

    J P G

     

     

  • November 15, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • November 16, 2004 at 7:02 am

    #530266

    If the restore fails, you can't use the database - it never restored. SQL Server is usually an 'all-or-nothing' system.

    -SQLBill

  • December 1, 2004 at 12:34 pm

    #532094

    I encountered a similar problem recently.  The solution was to stop SQL Server and delete the physical files (mdf & ldf) then restart SQL Server.  In this case, SQL Server recognized that the files were not available and made no attempt to load them.  I then recreated the database from the script originally used and the user was back in business, able to perform the restore.

    Hope this helps (even if late).

    Don

Viewing 4 posts - 1 through 3 (of 3 total)

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