Divine Flame (7/24/2014)
You should see somthing like "Recovering the database ...." & along the line it will also tell you the % of recovery completed. Wait for it to complete. If enough space is available then it should come online fine.
That's RECOVERING, not RECOVERY PENDING. There will be no such messages in the log and the OP could wait forever for what good it will do. A DB that is RECOVERY PENDING will not automatically come online.
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