I also had this issue today with my DEV DB server, and database was showing in Recovery Pending State.

On running the mentioned statement in one of previous responses, the database came back to normal:

ALTER DATABASE dbXYZ SET ONLINE WITH ROLLBACK IMMEDIATE