Backup policy details reports

Backup Policy Details report

This page explains how to view prebuilt backup policy details reports in BigQuery.

The Backup and DR Service provides prebuilt backup policy details reports that are accessible in BigQuery. You can access these reports after you execute the prebuilt script in the same dataset where the logs are being routed through the log sink. For more information, see backup policy details logs.

  • Last_Updated_On: The timestamp when the backup policy details information was last updated.
  • Backup_Template: The type of resource, for example, a Compute Engine instance.
  • Backup_Policy_Name: The name of the template that the backup policy is part of.
  • Backup_Policy_Type: The type of the backup policy. This can take two values: "Local Replication" or "Remote Replication"
  • Backup_Schedule_Type: Backup Schedule Type. It can be WINDOWED or CONTINUOUS.
  • Backup_Window_Start_Time: Backup Window Start time in HH:MM format. This field is applicable only for windowed schedule types. It is "N/A" by default for continuous backup schedules.
  • Backup_Window_End_Time: Backup Window End time in HH:MM format. This field is applicable only for windowed schedule types. It is "23:59" by default for continuous backup schedules.
  • Backup_Frequency_In_Days: The configured schedule frequency in days for the backup policy.
  • Backup_Consistency: This represents the kind of backup configured for the policy. Possible values are "Crash consistent backup", "Take application consistent backup" or "Crash consistent backup on last try". These are detailed in Configure advanced policy settings.
  • Log_Backup_Frequency_In_Minutes: The frequency at which database logs are backed up in minutes. This field is applicable only for database type applications, otherwise it is reported as 0 by default.
  • Backup_Retention_Period_In_Days: Retention period of backups in days. This field is in decimal format and shows up to 2 decimal places.
  • Protected_Resources_Count: Count of resources protected with the given template.
  • Schedule_Disabled_Resources_Count: Count of resources protected with the given template but with the schedule in disabled state.
  • Appliance_Name: The name of the appliance associated with the backup policy.