How to Recover a Database from Suspect or Recovery Pending State in SQL Server?

So one or more of your databases went into RECOVERY PENDING state or in SUSPECT mode and you are confused about what to do now to fix the issue immediately. Do not panic 😨 Almost every DBA has encountered this scenario quite a few times in their pro...