Missing log backup can cause loss of data. In case of database fault, we won’t be able to restore the database to 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 execute successfully every 1 hour.
What went wrong?
- No available disk space.
- Network is not available.
What to do:
- Check the backup system.
- Check server network connection