Complete the Databases Guided Setup for Google Cloud BigQuery

The Databases guided setup guides you through creating a backup plan and adding an Google Cloud BigQuery instance.

Go to the Databases Guided Setup

1. From the navigation pane, go to Guided setup.

   The Welcome page appears.

2. On the Protect tab, click the Databases tile.

   The Databases guided setup appears.

Create a Backup Plan for Google Cloud BigQuery

If you already have a backup plan that you can use, you can skip this step.

Before You Begin

To create a backup plan, you must have the Plan Creator Role assigned to your user account.

Procedure

1. On the Create backup plan page, click Create a new plan, and then specify the settings for a backup plan that you can use for the Google Cloud BigQuery instance.

2. Settings	Steps
   Plan name	Enter the following information: Choose whether to create a new backup plan or use a base plan. If you selected Create a new plan, in the Plan name, enter a name for the backup plan. If you selected Use existing base plan, specify the backup plan name and select a base plan.
   Backup destinations	Click Add copy. The Add copy dialog box appears. In Name, enter a name for the backup destination. From the Storage list, select the storage to use for the backups. You can use the Air Gap Protect cool storage class for creating secondary copies, but not for creating primary copies. To specify the start time for backups on a specific date and later, move the Backups On and After toggle key to the right. For Retention rules, enter the amount of time to retain the backups. To specify additional backups, such as weekly full backups, move the Extended retention rules toggle key to the right, and then add rules. Click Save. To add additional regions to the backup destination, move the Multi-region toggle key to the right, and then select the regions. You can also add more regions and associate the storage copy to the region.
   RPO	For Backup frequency, click Add. The Add backup frequency dialog box appears. From the Backup type list, select the backup type, and from the for list, select All agents or Databases. Specify the frequency of the backup. To specify the client time zone, full backup database frequency, or to add exceptions, move the Advanced toggle key to the right, and do the following: From the time zone list, select the time zone according to which the backups must run. If you select incremental or differential backup type for all agents or databases, to modify the full backup frequency of the database, specify a value for Run full backup on databases every option. To add exceptions when the backups must not run, click Exceptions, and then add exceptions for any day of a month or week or schedule an exception for any week of the month. Exceptions repeat every week or month according to the selected exception. To modify the transaction log frequency, or enable disk cache for log backups, in the Run transaction log for databases field, click Edit . For Transaction log, specify how often to run log backups. To automatically back up the database logs to the MediaAgent cache, move the Advance toggle button to the right and do the following: Move the Use disk cache for log backups toggle key to the right. For Commit every, enter how often to commit the logs to the CommServe computer. Disk caching of database logs applies to the following databases: Informix, Microsoft SQL Server on Windows, Oracle, Oracle RAC, and SAP HANA Note The database schedules are available only if the backup plan is applicable to database solution and only one transaction log schedule can be added to that specific backup plan. For Backup window (if incremental and differential backups are supported for the workload), specify when you want incremental and differential backups to run. For Full backup window, specify when you want full backups to run.
   Database options	Under Database options, do the following: For Log backup RPO, enter how often to run log backups. To automatically back up the database logs to the MediaAgent cache, do the following: Move the Use disk cache for log backups toggle key to the right. For Commit, enter how often to commit the logs to the CommServe computer. Disk caching of database logs applies to the following: Informix, Microsoft SQL Server on Windows, Oracle, Oracle RAC, and SAP HANA.
   Override restrictions	Leave the Allow plan to be overridden check box cleared.

3. Click Save.