Elliott Whitlow (10/21/2011)
If the files have moved I don't see much of a choice..
Move them back where they should be and offline/online or ALTER DATABASE ... MOVE then offline/online. Or restart SQL instead of the offline/online combo if there's nothing else running on the server.
I would be very, very cautious about detaching a database in anything other than Online state as if it doesn't reattach the situation's just got worse.
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