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.
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