Overview

Archiver SQL databases show as being in Recovery Pending mode when viewed in SQL Management Studio.

Solution

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:

Query output

Note: This issue is outside our scope of support, so kindly follow the steps above for a solution.

Articles in this section

Overview

Solution