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.

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 modification done on the database (insert,update).

Normally:

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