Stay organized with collections
Save and categorize content based on your preferences.
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.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-29 UTC."],[],[],null,["# Backup policy details reports\n\nBackup Policy Details report\n----------------------------\n\nThis page explains how to view prebuilt backup policy details reports in BigQuery.\n\nThe Backup and DR Service provides prebuilt backup policy details reports that are\naccessible in BigQuery. You can access these reports after you execute the\nprebuilt script in the same dataset where the logs are being routed through the\nlog sink. For more information, see\n[backup policy details logs](/backup-disaster-recovery/docs/monitor-reports/backup-policy-details-logs).\n\n- **Last_Updated_On**: The timestamp when the backup policy details information was last updated.\n- **Backup_Template**: The type of resource, for example, a Compute Engine instance.\n- **Backup_Policy_Name**: The name of the template that the backup policy is part of.\n- **Backup_Policy_Type**: The type of the backup policy. This can take two values: \"Local Replication\" or \"Remote Replication\"\n- **Backup_Schedule_Type**: Backup Schedule Type. It can be WINDOWED or CONTINUOUS.\n- **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.\n- **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.\n- **Backup_Frequency_In_Days**: The configured schedule frequency in days for the backup policy.\n- **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](/backup-disaster-recovery/docs/create-plan/policy-settings).\n- **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.\n- **Backup_Retention_Period_In_Days**: Retention period of backups in days. This field is in decimal format and shows up to 2 decimal places.\n- **Protected_Resources_Count**: Count of resources protected with the given template.\n- **Schedule_Disabled_Resources_Count**: Count of resources protected with the given template but with the schedule in disabled state.\n- **Appliance_Name**: The name of the appliance associated with the backup policy."]]
