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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability