SQL: LOG BACKUP

MS-SQLSQL
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.

    Signup for the latest news and updates



    Share with friends:

    Testimonials:

    FEATURED POSTS

    Menu