Check our article on Backup failures to understand possible causes and action recommendations.
Missing log backup can cause a loss of data. In case of a database fault, we won’t be able to restore the database to the current point in time.
Log backup covers the part of the transaction log that was active when the backup was created, and it includes all log records that were not backed up in a previous log backup.
Transaction log contains all data modifications done on the database (insert, update).
Log SQL backup should be generally executed successfully every 1 hour.