• Once the log either be backed up (Full Recovery Mode) or truncated (Simple Recovery Mode), Only the active transactions and committed transactions since last log backup or checkpoint are in the log file.