Depending on the number of transactions it may well happen that transaction logs grow fairly massive instead of realizing what is while in the transaction log or the amount of space is occupied by it could cause some troubles. The third part with the code reveals the most recent total backup, differential backup, and Log backup with the databases