Scheduling Backups and Schedule Conflicts
We are looking to do full backups once a day (say, at 1:00 am), differential backups hourly throughout the day and transaction log backups as often as possible (ideally, every 15 minutes or less).
Can you please confirm what is the simplest, most efficient way to accommodate this requirement whilst avoiding scheduling conflicts on the SQL Backup Pro timeline, please? Is it creating multiple disjoint schedules for the differential and transaction log backups? For example, for the transaction log backups, creating a different schedule for each hour in the day, leaving gaps in each to accommodate the differentials and full backups