GilaMonster (7/24/2014)
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.
Yes. I got confused with Recovery_Pending as RECOVERING. Thanks Gail for clearing that one over there.
one more question out of curiosity:
You said:
GilaMonster (7/25/2014)
From your description of what you did, it was in the recovery_pending state. What you did would not have fixed a suspect database. Setting to emergency wasn't necessary, a simple set ofline, set online would have worked once space was freed up.
However, OP said in his first post that he has restarted the SQL Server instance after making the free space. Why didn't the database come online at that point?