Archiver SQL databases show as being in Recovery Pending mode when viewed in SQL Management Studio.
As a solution, you can run the following command and replace *Database Name* with the name of the database. Make sure that you create backups beforehand.
ALTER DATABASE [*Database Name*] SET EMERGENCY; GO ALTER DATABASE [*Database Name*] set single_user; GO DBCC CHECKDB ([*Database Name*], REPAIR_ALLOW_DATA_LOSS) WITH ALL_ERRORMSGS; GO ALTER DATABASE [*Database Name*] set multi_user; GO
If the command completes with errors, investigate and correct any errors located.
If the command is successful, the database should be functional. To see a list of databases and their status run the following query:
SELECT name, state_desc from sys.databases; GO
You should see output similar to the following:
Note: This issue is outside our scope of support, so kindly follow the steps above for a solution.