I have the same situation like this thread. https://ask.sqlservercentral.com/questions/97444/sql-database-stuck-in-recovery-pending.html
As it is very old thread so, I am creating the new question. I am using SQL 2012. Please help me to fix this problem as soon as possible.
Answer by Tim ·
How long has it been in recovery pending? Have you been able to run DBCC CHECKDB to see if you have any level of corruption? Recovery pending usually isn't the end of the world, I've been able to backup databases and transaction logs in a recovery pending state. Provide more details about your specific issue, not just referencing an old thread. What are your circumstances that got you here, what have you specifically done since the issue happened. The more details the better.