9 Posts
0
1060
June 29th, 2021 12:00
SQL full backup
Hi,
I would need some guidance regarding SQL backups
I have created a Policy and the schedule is: Monday-Saturday logs only (every 60 minutes), Sunday full.
Logs only work great every one hour. However, when it comes to full backup on Sunday, Networker is taking only full backups. This is resulting of having a couple full backups and no logs only backup.
I was under the impression that Networker will take a full backup (based on schedule) and then it will continue with logs only backups during the same day.
Am I missing anything here or this is an expected behavior?
Thank you in advance.
No Events found!
Federal2004
9 Posts
0
July 17th, 2021 13:00
@crazyrov
My backup schedule was:
Start time: 18:00 PM
Interval: 20 minutes
Interval End: 18:00 PM
Restart Window: 20 minutes
After setting "Force Logs Only", Networker was taking Logs Only backups regardless the schedule being Sunday full - Logs only the rest of the days.
I then changed the schedule to:
Start time: 12:20 AM
Interval: 20 minutes
Interval End: 11:42 PM
Restart Window: 20 minutes
And it worked... During Sunday i got 1 full backup and at 00:20 and logs only after that...
crazyrov
4 Operator
•
1.3K Posts
0
July 3rd, 2021 23:00
@Federal2004, for the behavior that you are looking for just set "Force backup level" to "logs only " and leave the schedule for Sunday as "Full".
Federal2004
9 Posts
0
July 8th, 2021 01:00
Hi @crazyrov
I setup the "Force Backup level" to Logs-Only 2 days ago but when the full backup run today, Networker took Logs Only backup..
crazyrov
4 Operator
•
1.3K Posts
0
July 11th, 2021 22:00
@Federal2004 Can you go back and check the backups again? There should be at least one full level on the day where the level was set to full on the action schedule.