Performing 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.
Due to technical limitations in Google Cloud, 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, if it has been recently deleted (less than a week ago), or if its name is reserved.
How SQL Restore Works
To restore a Cloud SQL instance from a cloud-native snapshot, Veeam Backup for Google Cloud first creates a Cloud SQL instance in the target location and then uses native Google Cloud capabilities to revert the instance to the snapshot.
To restore a Cloud SQL instance from an image-level backup, Veeam Backup for Google Cloud performs the following steps:
- Creates a Cloud SQL instance in the target location.
- Deploys a worker instance in the Google Cloud region in which the repository with backed-up data is located.
- Exports databases, triggers, stored procedures and users of the processed the Cloud SQL instance to a SQL dump file in the Temp folder of the storage bucket where the backup repository resides.
For more information on SQL dump files, see Google Cloud documentation.
- Imports the exported databases, triggers, stored procedures and users to the created Cloud SQL instance.
- Removes the worker instance from the Google Cloud environment.
How to Perform SQL Restore
To restore a protected Cloud SQL instance, do the following:
- Launch the Cloud SQL Instance Restore wizard.
- Select a restore point.
- Choose a restore mode.
- Select a project.
- Select a region and an availability zone.
- Specify a new name and machine type for the instance.
- Configure network settings.
- Configure security settings.
- Enable flag assignment.
- Specify a restore reason.
- Finish working with the wizard.
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.