DBCC CHECKDB ([YourDatabaseName]) WITH NO_INFOMSGS, ALL_ERRORMSGS;
Here’s a concise guide to understanding and resolving state in SQL Server. database recovery pending
When SQL Server starts up, it runs a recovery process for every database to ensure they are transactionally consistent. It rolls forward committed transactions and rolls back uncommitted ones found in the log. DBCC CHECKDB ([YourDatabaseName]) WITH NO_INFOMSGS
This puts the database in read-only mode and marks it for repair. database recovery pending