Veeam Prerequisites for SQL Transaction Log Backup

Any database that you want to be backup up needs to have two settings checked.

The Recovery model of the database needs to be in Full.

The Auto Close settings needs to be set to False