Sapen (7/11/2013)
Check for the location where your ldf and mdf files are and As long as you have them try doing a detach/attach and it should bring the database to a normal state.
No.
A database that is in any suspect/recovery_pending status should not be detached. A database so detached may well not reattach, meaning you've gone from a database in the recovery_pending state that you may be able to fis, to a bunch of files in the file system that you can't do much with.
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