Also check:
This will tell you the extent of the damage.
Ensure drive holding tempdb , data, or log has enough space. database recovery pending
DBCC CHECKDB ([YourDatabaseName]) WITH NO_INFOMSGS, ALL_ERRORMSGS;
ALTER DATABASE [YourDatabaseName] SET MULTI_USER; ALTER DATABASE [YourDatabaseName] SET ONLINE; Also check: This will tell you the extent of the damage
⚠️ Not to be confused with Suspect mode (integrity issue) or Recovering (normal startup).
Seeing a status on your SQL Server database can be stressful, but it doesn't always mean your data is lost. Unlike a "Suspect" state, which signals a failed recovery, "Recovery Pending" means SQL Server knows it needs to run recovery but is being blocked from starting the process. What Does "Recovery Pending" Mean? Seeing a status on your SQL Server database
If data file is intact but log is missing/corrupt:
SELECT name, state_desc, recovery_model_desc FROM sys.databases WHERE state_desc = 'RECOVERY_PENDING';