SQL: Log backup

Risk :

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 modification 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 backup system.
  • Check server network connection