Scheduling Backups
Full backup is a job type in which all selected files, regardless of prior state, are backed up.
- most basic and complete type of backup operation
- all the data is copied to a storage device or cloud storage location
- Need reliable and timely backups to comply with an org’s recovery time objectives (RTO) and recovery point objectives (RPO)
- schedule regular backups at consistent times
- full backup serves as a base for other types of backups
- advantage of a full backup:
- a complete copy of all data is available with a single set of media
- offers the best protection
- requires the least amount of time to restore the data
- main disadvantage:
- takes significantly longer to perform than other types of backups
- requires more storage space
- typically perform periodic full backups combined with other backup types
Scheduling Strategy
- Several questions to answer when creating a scheduling strategy:
- What needs to be backed up?
- don’t want to back up more than you need
- adds to the time it takes to back up and restore databases
- don’t want to back up more than you need
- What business requirements impact the timing of the schedule?
- Are there any other processes that affect the timing of your backup?
- needs sufficient resources
- backup should never consume resources necessary to keep a production system operating properly and at peak performance
- What business requirements impact how often it should be scheduled?
- driven by the organization’s RPO for that data
- priority level of the data is also a factor
- Three of the most common backup schedules:
- Nightly full backups
- Weekly full backups followed by nightly differential backups
- Weekly full backups followed by nightly incremental backups
- Is automation an option?
- automation is the preferred option when available
- Automation ensures that the backup is performed when it is supposed to be
- Scheduling software is typically used to automate backups
- can be configured to send notifications when the backup has started and when it is complete
- What needs to be backed up?