Home Forums Database Design Disaster Recovery Does the full backup clear/truncate the t-log? RE: Does the full backup clear/truncate the t-log?

  • November 14, 2011 at 9:37 am

    #1407328

    JakeSA (11/14/2011)

    Or maybe you mean that inactive logs entries are marked as having been backed up in a t-log backup so that they can be overwritten?

    I mean exactly what I say. 🙂 Nothing ever removes log records from the log. A log backup marks active VLFs as inactive. Once inactive they can be overwritten.

    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