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.
Aron, did you read the answer of referred thread? As Grant mentioned in the answer, restore from the updated backup or go with the DBCC CHECKDB REPAIR ALLOW DATA LOSS Option.
Regards,
Dazy
Hello Ms Parker,
Thank you for your reply
as using dbcc checkdb repair_allow_data_loss could be the reason of data loss so, I am afraid to using it. .bak is not updated and we are facing corruption. any other option?
Repair allow data loss could be the reason of data loss. In this case, I will refer this article: https://bit.ly/2Id58f9
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.
19 People are following this question.
