GilaMonster (2/14/2016)
manub22 (2/13/2016)
On running the mentioned statement in one of previous responses, the database came back to normal:ALTER DATABASE dbXYZ SET ONLINE WITH ROLLBACK IMMEDIATE
That only works after whatever caused the RECOVERY_PENDING state has been fixed.
An example of this:
We had a data drive and TLog drive fill up on an old dev server which put one of the databases in RECOVERY PENDING.
Once some space was cleared in the databases, files shrunk etc, I ran the above statement to recover the situation.