To fix a database that is in Recovery Pending status, try executing this query:

ALTER DATABASE MyDB SET ONLINE

where MyDB is the name of the database