Could you please check the script for the transaction log backup job? Does it name the databases explicitly e.g.
BACKUP LOGS [db1, db2, ...] TO ...
If so, you'll need to add new databases to the list as and when they are created. You could amend the list to back up the transaction log for all databases running full/bulk logged recovery models e.g.
BACKUP LOGS [*] TO ...
or use an exclusion list e.g.
BACKUP LOGS EXCLUDE [db1, db2] TO ...
which will back up all databases running full/bulk logged recovery models except those listed.
However, the last 2 options will not automatically run a full backup if the transaction log backup job runs before the full backup. The next version of SQL Backup (7.2) will address this.
SQL Backup Consultant Developer
Associate, Yohz SoftwareBeyond compression
- SQL Backup goodies under the hood, updated for version 8