Page 1 of 1

Work logic Differential Backup

Posted: 25 Jan 2021, 07:58
by Paltus
Hello colleagues!
Created the following job:

Image

Image

Image

Image

When performing this task, I get only two Differential Backup, but I can't get the FULL one! I attach the log. Tell me where the error is, or such logic?But this is wrong.

Re: Work logic Differential Backup

Posted: 26 Jan 2021, 07:02
by cobian
You are keeping only 2 differential backups. This means that the total number of backups will never be bigger than 3 (2 differentials plus one full). You will never get up to 4 unparked backups to trigger another full backup. Change the Make one full to 3 instead. Or Number of differential to keep up to 3.

Re: Work logic Differential Backup

Posted: 26 Jan 2021, 12:11
by Paltus
Good day!
Dear Luis!
I assumed and still assume the following algorithm.
We shouldn't substitute two concepts:
1. Make one full every
2. Differential copies to keep
Will explain.
The option that you propose is absolutely normal. But the question. Why then field Differential copies to keep? If we set the value 6 in the Make one full every field, then it is clear that all copies between full copies will be stored.

Image

And I'm talking about STORAGE! To restore information, we need to have the last full backup and the last differential backup. So we will store the last 2 differential backups. And make full copies after the specified number in the Make one full every field. I tried to explain in the pictures.

Image

Image

Image

Image

Image

Image

Image

Image

So. The first execution in the task is a full backup (in the picture # 1). Then differential and so on 6 times until complete. The second execution in the task is differential (in the picture # 2).
The third is differential (no. 3). But while maintaining the fourth execution (on picture No. 4), it should replace No. 1. The fifth is to replace the second. The sixth is the third. Etc. As a result, we should get such a structure.

Re: Work logic Differential Backup

Posted: 09 Feb 2021, 17:34
by Paltus
And if you apply such an algorithm? Sorry, I'm not a programmer.
k - variable for FULL
m- variable for DIFF

A - Differentil copies to keep
B - Make one full every
C- Full copies to keep