メインコンテンツまでスキップ

Export Backup

Export Backup creates a logical backup of a selected database. VeloDB Cloud exports the database to VeloDB-managed object storage and imports it during restore, using a cluster you choose to run the backup and restore tasks. Use this mode when you need database-level recovery, partial recovery, or migration to another warehouse.

Export Backup is available in VeloDB Cloud 4.0 and later. If your warehouse runs a supported version earlier than 26.1, or Lightweight Snapshot is not enabled for your account, use Export Backup.

This page covers creating an Export Backup plan. To decide between the two backup modes, see Choose a backup mode. For viewing tasks, configuring plans, and restoring, see Backups. If you need warehouse-level recovery instead, use Lightweight Snapshot.

Limitations​

Export Backup is built on the VeloDB Cloud export feature, so it can back up only what export supports. Objects with data types that export does not support cannot be backed up.

  • Export Backup covers the selected database, not the full warehouse.
  • Restore speed depends on data volume, file count, import throughput, and target warehouse resources.

Export Backup cannot back up the following objects in any version:

  • Nested IP-type fields, where an IP type appears in an array, map, or struct.
  • Special aggregate state fields, including agg_state and quantile_state.
  • The storage_policy table property.
  • Complex view dependencies, such as multi-level nested asynchronous materialized views or view dependency relationships that cannot be fully identified.

To continue a run when it encounters an unsupported object, enable Skip unsupported objects in the plan. Review the task details after each run to identify anything that was skipped.

Prerequisites​

Before you create a plan:

  • Confirm that you have access to the source warehouse and the database that you want to back up.
  • Confirm that the selected cluster has enough spare capacity for the backup task. Export Backup consumes compute resources while it runs.
  • Choose a backup cycle and retention period that match your recovery point objective. Your effective recovery point is the most recent completed backup.
  • The cluster is in Running status. If the cluster is paused, you cannot create a backup plan. The cluster must also be in Running status when the plan executes, so make sure it is not paused or scaled down to zero before the backup starts.

Create an Export Backup plan​

To create an Export Backup plan, follow these steps:

  1. Log in to the VeloDB Cloud console.

  2. In the upper-left corner, select the warehouse that you want to use.

  3. In the left navigation pane, under MORE, click Backups.

  4. On the Backups page, select Export Backup, then in the upper-right corner, click Create Backup Plan.

  5. Select the backup type.

    • To back up your data periodically, select Periodic Backup and leave Enable on. Use Enable to turn the periodic plan on or off without deleting its configuration. In Backup Every, select at least one day from Monday through Sunday. You can select any combination of days.
    • To back up your data once, select One-time Backup. This plan runs once and does not create a recurring schedule.

  6. Set Start Time, which determines when each backup run starts, and confirm the time zone shown by the console.

  7. In Performance mode, choose the performance mode.

    • Low impact uses fewer resources and may take longer.
    • Max performance uses more warehouse resources and may affect running workloads.

  8. Select the database and backup objects in Backup Objects.

    • For an Internal Catalog, VeloDB Cloud backs up the full database.
    • For an External Catalog, VeloDB Cloud backs up DDL only, not data.

  9. To continue the task when objects with unsupported data types are encountered, enable Skip unsupported objects. These objects are excluded while the backup continues for all other objects. Review the task details after each run to identify anything that was skipped.

  10. Set Retention (Days) to specify how many days each backup set is retained. Backup sets older than this value are eligible for automatic cleanup. The minimum retention period is 1 day.

    Note:

    VeloDB Cloud cleans up expired backups according to the retention period only after an automated backup succeeds. A failed run does not delete existing successful backups.

  11. Select the Backup Cluster that will provide compute resources for the backup. When the warehouse has multiple clusters, select one with enough spare capacity for the backup workload.

  12. Click Confirm. The button remains unavailable until all required fields are complete.

Review backup task status after creating a plan to confirm that backups complete successfully.

View backup tasks​

VeloDB Cloud runs backup tasks automatically according to the saved plan. The Backup Tasks list shows each run's status, retention days, data size, start time, and completion time.

To view backup tasks, follow these steps:

  1. Log in to the VeloDB Cloud console.
  2. In the upper-left corner, select the warehouse that you want to use.
  3. In the left navigation pane, under MORE, click Backups.
  4. In the Backup Tasks list, review the status of each backup task. The status can be Success, Failed, or Running.
  5. In the action column, click View Details to see execution details for a backup task. Confirm that the task succeeded, note the data size and completion time, and investigate any skipped objects or error messages before treating the backup as a usable recovery point.

Configure a backup plan​

After you create a backup plan, you can change the backup type, schedule, retention period, and performance mode. You can also enable or disable a periodic plan without deleting its configuration.

If you do not need a backup plan any longer, you can delete it, which removes the configuration and stops future backups. The console does not delete existing backup sets when you delete a plan.

Before you configure a backup plan, ensure that the warehouse is in Running status. If the warehouse is paused, you cannot configure the backup plan.

To configure a backup plan, follow these steps:

  1. Log in to the VeloDB Cloud console.
  2. In the upper-left corner, select the warehouse that you want to use.
  3. In the left navigation pane, under MORE, click Backups.
  4. On the Backups page, in the upper-right corner, click Configure Backup Plan. The console displays the current plan configuration.
  5. Change the backup type, schedule, retention period, and performance mode as needed. You can enable or disable a periodic plan without deleting its configuration. You can also delete the plan, which removes the configuration and stops future backups. VeloDB Cloud does not delete existing backup sets when you delete a plan.
  6. Click Confirm.

Review backup task status after changing a plan to confirm that backups complete successfully.

See also​