Predefined Server Plan Schedule Policies

Updated

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: The frequency of backup jobs. By default, an incremental backup job runs everyday at 9:00 AM, according to the time zone of the client.

    Note:

    • You can modify the default backup job schedule, or click Add and schedule additional full, differential, and incremental backup jobs.

    • You can delete all backup schedules, including the default incremental backup job.

  • Backup window: The days and times when you want incremental and differential 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.