• It "Depends". What type of backup and what recovery model is the database using?

    A full backup and differential backup do not truncate the transaction log. Enough of the transaction log is backed up during these backups to provide a consistant backup.

    The transaction log is truncated (when a database is in bulk-logged of full recovery model) when a transaction log backup is completed.

    😎