Symptom: You found a database that is restoring/loading mode after so many hours (or days) and after refresh, the database is still restoring.
Why: This usually occurs due to an ‘unclean’ connection. For example, a client who initiated the restore, was disconnected during the process, leaving the Restore ‘hanging’. Or you might forget to include WITH RECOVERY in your restore script.
Fix: Run RESTORE DATABASE [database_name} WITH RECOVERY to complete roll forward. All things failed, you may have to resort to dropping the database and restoring from backup (make sure you include RECOVERY in your restore script).
