SQL: LOG BACKUP

MS-SQLSQL

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

    Signup for the latest news and updates



    Share with friends:

    You may also like this:

    RECENT POSTS

    Menu