Check our article on Backup failures to understand possible causes and action recommendations.
Risk:
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.
Description:
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).
General recommendation:
Log SQL backup should be generally executed successfully every 1 hour.
