• 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass