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 [...]
Posts Tagged ‘restore’
Database Stuck In Restoring State
Posted in SQL Server, tagged restore, workaround on 5 May 2009 | Leave a Comment »