Database hung "Loading"

  • Did you restore with EM or QA?

    Don't trust EM, use QA instead and don't forget to code "with recovery" as your last step.

    Franco


    Franco

  • I had this same problem 2 days ago. I run SQL 2000 sp3. When attempting to restore a production backup to a test database, I didn't have enough room for the log file to increase. EM gave the warning, canceled the restore process, yet left the database in "LOADING" status. Couldn't find any other alternative than to delete the database, recreate it, free up the needed space and restore. The backup file itself was not corrupted. Just goes to show the importance of good, clean backups (imagine this happening on a production db!!).

    Terry


    Terry

  • You guys are great! We're still beginners, using EM mostly. Will try using QA more, and 'with recovery' next time!

  • After all else has failed and the status is still "loading" would it make sense to create and tune sp_resetstatus?

Viewing 4 posts - 16 through 19 (of 19 total)

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