How to Recover SQL Database from Emergency Mode to Normal Mode?įollow these steps to manually repair a SQL database and restore it to normal mode.
Note: if your database goes into SUSPECT state due to corruption, setting it to ONLINE state will just return a database in SUSPECT status. But, if the database seems stuck in EMERGENCY mode, try to bring it ONLINE by executing this command: ALTER DATABASE database_name SET ONLINE Since the database is under repair, it might take you a few minutes to bring the database back online. Setting a database in EMERGENCY mode helps access the database and run a repair on it using DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSS command. Essentially, when a database status is changed to SUSPECT, it becomes inaccessible. The EMERGENCY mode is a read-only status used to read data from databases in the RECOVERY PENDING/SUSPECT mode. It also discusses an alternative solution, using a SQL recovery tool to quickly restore the inaccessible database to its original (normal) state, without data loss. This blog explains the steps following which you can recover a SQL database from EMERGENCY Mode to NORMAL Mode. At times, when attempting to bring the database back to normal mode, the database is stuck in EMERGENCY mode. Emergency mode is used to access a database marked in RECOVERY PENDING or SUSPECT state.