Full backup, Incremental backup, and differential backup

Basic concepts:

Full backup: a complete backup;
Differential backup: The above full backup is a basic backup;
Incremental Backup: The above full backup or Incremental backup is a basic backup.

After reading the concept, is it still confused? Haha, normal! But it doesn't matter. The following is an example. If the version library is not large, you can directly perform full backup. However, if the version library has several or even dozens of GB, you need to use the following solution.

Example:

Full backup + Incremental backup solution: If we perform full backup on Monday, Incremental backup on Tuesday is based on Monday, and Incremental backup on Wednesday is based on Tuesday, and so on...
Full backup + differential backup solution: Full backup is performed on Monday, and differential backup on Tuesday is performed on Monday. Differential backup on Wednesday is performed on Monday, and so on...

Comparison of solutions:

Full backup + Incremental backup makes recovery troublesome (you need to recover the previous Incremental backup to the full backup in sequence. For example, to recover the backup on Thursday, you need to recover the Incremental backup on Thursday in sequence, incremental backup on Wednesday, Incremental backup on Tuesday, full backup on Monday), but saves space;

Full backup + differential backup make it easier to recover (only the differential backup on the current day and the full backup on Monday are restored), which takes up a little space.