The database state (from sys.databases) is RECOVERING?
If so, wait. There's nothing that you can do to magically bring it out of recovering, the recovery process must complete.
The progress of the recovery process will be recorded in the error log.
Do NOT restart SQL, it will start the recovery process over from scratch.
Do NOT try to drop the database or do anything to the database files, at best it'll do nothing at worst it'll leave you needing to restore from backups
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