Performing SQL Instance Restore

In case a disaster strikes, you can restore an entire Cloud SQL instance from a cloud-native snapshot or image-level backup. Veeam Backup for Google Cloud allows you to restore one or more Cloud SQL instances at a time, to the original location or to a new location.

Note

Veeam Backup for Google Cloud does not support restore to the original location if the source Cloud SQL instance is still present in the location or if its name is reserved. However, note that if you delete an instance from Google Cloud, all its cloud-native snapshots will be deleted as well due to technical limitations in Google Cloud.

To restore a protected Cloud SQL instance, do the following:

  1. Launch the Cloud SQL Instance Restore wizard.
  2. Select a restore point.
  3. Choose a restore mode.
  4. Select a service account.
  5. Select a project.
  6. Select a region and an availability zone.
  7. Specify a new name and machine type for the instance.
  8. Configure network settings.
  9. Configure security settings.
  10. Enable flag assignment.
  11. Run configuration and permission checks.
  12. Specify a restore reason.
  13. Finish working with the wizard.

Important

Before you start Cloud SQL instance restore, make sure that network settings are configured for each region where worker instances will be deployed during the restore process. For information on how to configure network settings, see Adding Worker Configurations.