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
    • 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