SQL Server Transactional log backup is larger than full backup

Question

Transaction log backup is 450 mb but the full backup size is 10mb.

• BackupType: 2
• HasBulkLoggedData:0
• RecoveryModel:Full
• BackupTypeDescription :Transaction Log
• auto growth setting : By 512 MB, Limited to 2097152 MB
• correction, the size of the mdf file is 512 MB
• current LDF size is around 450 MB every 15 minutes.
• Full backup size is 11 MB

Answer 1

In simple terms, the transaction log backup contains activity, but the full backup just contains data.

For example, if you have an empty table, insert 100 rows, then delete all 100 rows, the table will still be empty. The full backup will just be the empty table, but the transaction log backup will record the 100 inserts and deletes.