I have a SQL SERVER DB that i want to backup via automated schedule (using GUI maintenance plan) . I have 2 choices when configuring a schedule :
1) do not bother about log backup , full backup and diffrencial bakcup event time , as if all the 3 backups occur on same time , it makes no difference .
2) make sure that log backup, full backup and differential backup never occur in same time by configuring carefully the time of each backup.
Below is the image describing the 2 choices (Schedule1 for choice 1 and chedule2 for choice 2 )
Do you know which one is the best ?
Edit : Sechdule1 may face some errors when backups are overlaping . Here the backups are of type log and differential hapening same time at 5:30 as the backup whatever the type is will be appended to the existing backup file. So the file was in use by log backup and differential failed . Even if no data was lost.