• a_ud (5/1/2015)


    -The DB model was in Full recovery mode, log_reuse_wait_desc: LOG_BACKUP (I take this means the TLOG has been backed up? and not that is waiting for it.

    No, that means that the DB needs a log backup before the log can be reused.

    Please get and read the book Jacob recommended.

    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