SQL: DIFFERENTIAL BACKUP

MS-SQLSQL
Check our article on Backup failures to understand possible causes and action recommendations.
Risk:

Missing a differential backup may cause a loss of data. In the case of database fault, we won’t be able to restore the database.

Description:

A Differential backup contains all the data in a specific database or set of file groups or files since the last Full backup.

A Differential backup cannot be executed without Full backup, but it is smaller and faster to create than the base of a full backup, and it also requires less disk space to store backup images

General recommendation:

Differential SQL backup should execute successfully every 24 hours.

    Help me to improve my IT environment!



    Share with friends:

    Testimonials:

    FEATURED POSTS

    Menu
    Skip to content