Skip to main content

Restore from a Backup

Restoring an Export Backup recovers a selected database for partial recovery or migration. Restoring a Lightweight Snapshot recovers an entire warehouse. Restore a Lightweight Snapshot to the current warehouse when you need to return a workload to service, or to a new warehouse when you need to validate the recovered data before switching traffic.

Warning:

Restoring to the current warehouse may affect the production warehouse. Restore to a newly created warehouse when you need to validate the recovered data before switching traffic.

Prerequisites​

Before you restore:

  • You have created a backup plan and confirmed that at least one backup set has completed successfully.

  • Identify the backup set by its completion time and retention period. If the restore could affect production, prepare an isolated or newly created warehouse for validation.

  • Test restore with production-scale data before you rely on a backup plan for critical workloads. Restore time grows with data volume and cluster capacity.

Note:

You can only restore from a backup in Success status. If the backup task failed, you cannot restore from it.

Restore an Export Backup or Lightweight Snapshot​

To open the restore dialog for either mode, follow these steps:

  1. Log in to the VeloDB Cloud console.
  2. Select the warehouse in the upper-left corner.
  3. Click Backups in the left navigation pane under MORE.
  4. Click Restore in the action column of the backup set you want to restore.

The restore options then depend on the backup mode.

Restore an Export Backup​

  1. Select the target warehouse and database.

  2. Select the performance mode.

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

  3. Click Confirm.

Restore a Lightweight Snapshot to the current warehouse​

  1. Click Current Warehouse.
  2. Click Confirm.

Restore a Lightweight Snapshot to a new warehouse (Clone a warehouse)​

Restoring to a new warehouse creates a clone of the source warehouse. For more information, see Clone a Warehouse.

Lightweight Snapshot restore is metadata-based and does not use performance modes.

View restore tasks​

The console creates a restore task and starts the restore process. The restore task appears in the Restore Tasks list with task status, data size, start time, and completion time. To see execution details, click View Details in the action column.

After the restore task completes, verify the restored database, tables, row counts, and representative queries before directing production traffic to it. For a restore to a new warehouse, also verify connections and permissions required by the application.

See also​