GilaMonster (10/19/2011)
No. Never ever detach a suspect or recovery_pending database as it will not always reattach (suspect will never reattach)Are you absolutely sure that file is there? Exact path, exact name.
Was there a drive problem that the drive came online later than SQL? If so, try restarting SQL Server.
I agree it won't always re-attach.. If all the files are there and in the exact same place then a restart probably won't hurt. If the files have moved I don't see much of a choice.. Luckily I don't have to deal with this kind of problem often..
CEWII