• dcyoung (3/15/2013)


    No errors and the same informational messages on my servers that don't have this problem.

    Can you post the error log, from startup to the time you offline/online the DB? That's assuming auto_close isn't on, if it is, that's possibly the problem, along with a long recovery time.

    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