The EMERGENCY mode is a perused just status used to peruse information from data sets in the RECOVERY PENDING/SUSPECT mode. Basically, when a data set status is changed to SUSPECT, it becomes distant. Setting a data set in EMERGENCY mode helps access the data set and run a maintenance on it utilizing DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSS command.
ALTER DATABASE database_name SET ONLINE
Prior to continuing, check assuming the data set is still in EMERGENCY mode by running the accompanying command:
SELECT name, state_desc FROM sys.databases WHERE name = Test_Database
Before to beginning the maintenance method, it means quite a bit to change the data set to SINGLE_USER mode to keep different clients from utilizing the data set.Once the database is in SINGLE_USER mode. You can repair it by excuting a DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSS.
ALTER DATABASE Test_Database SET SINGLE_USER WITH ROLLBACK IMMEDIATE DBCC CHECKDB (Test_Database, REPAIR_ALLOW_DATA_LOSS)
The CHECKDB command runs successfully without any consistency errors.
Now, Switch the data in multi user mode Using this command
ALTER DATABASE Test_Database SET MULTI_USER
Refresh your database and check it one more time. I believe it will work for you. If It is not working, Please comment here.