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 Software
- SQL Backup goodies under the hood, updated for version 7