Loading...

Predefined Server Plan Schedule Policies

Server plans include a predefined schedule policy for data backup jobs and a predefined schedule policy for log backup jobs.

The schedule policy names are derived from the server plan name. For example, the following schedule policies are included with a server plan named Test:

  • Test
  • Test Log schedule policy for the database clients

RPO Settings

You can modify the schedules by modifying the RPO (recovery point objective) settings for the server plan:

  • Backup frequency: How often incremental backup jobs run. The time is according to the time zone of the computer that is backed up.
  • Add full backup: Enable full backup jobs.
  • Full backup frequency: If you enable a full backup job, specify how often and what time you want the full backups to run. The time zone is according to the time zone of the computer that is backed up.
  • Backup window: The days and times when you want incremental backups to run.
  • Full backup window: The days and times when you want full backups to run.

Automatic schedules and dynamic priorities are used to achieve your RPO, based on these settings.

When Incremental Backups Are Converted to Full Backups

By default, each predefined schedule policy consists of an incremental backup schedule and a synthetic full backup schedule. The jobs from the incremental schedule are automatically converted to a full backup job based on the following backup conversion rules:

  • For SQL agents:
    • If the most recent full backup job is older than 30 days and the operation window allows a full backup job, the job is converted to a full backup job.
    • If the most recent full backup job is within 30 days and the most recent differential backup job is older than 7 days, the job is converted to a differential backup job.
  • For other agents: If the most recent full backup job is older than 7 days and the operation window allows a full backup job, the job is converted to a full backup job.

Related Topics

Last modified: 4/13/2021 4:43:38 PM