• Then...

    GilaMonster (4/18/2013)


    If you're getting that error when backing up, then the database you're trying to back up is not accessible. Don't try things like taking it offline/online without looking at the root problem first, they could make matters worse.

    What exactly are you trying to do, what are the exact error messages and what messages are in the SQL error log?

    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