The DatabaseBackup job created by Maintenance Script will introduce delay for the last database being backed up.
What I mean is, there are 6 databases around 200GB each.
- The FULL backup takes around 90minutes to complete.
- The backup jobs is scheduled to run at 2AM.
- So, the last 2 databases to be backed up will potentially run on business hours (after 8AM)
1st DB will complete on 3:30 AM
2nd DB will complete on 5:00 AM
3rd DB will complete on 6:30 AM
4th DB will complete on 8:00 AM
5th DB will complete on 9:30 AM
6th DB will complete on 11:00 AM
All the data files are on E: drive
Does it take same amount of time even when the backups are made to run at the same time at 2AM(by different jobs) due to IO overhead?
Is this the normal way the FULL backups are made (with delays)?