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
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass