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:34 am

    #1407322

    JakeSA (11/14/2011)

    p.s. Nothing deletes inactive log records from the log. Ever.

    Hmmm, then how are the spaces freed up in the log file? 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?

    The log doesn't autoshrink to free the space back to the OS.

    The vlf are marked as resusable.