Performing Database Restore

In case a disaster strikes, you can restore corrupted databases of a Cloud SQL instance from an image-level backup. Veeam Backup for Google Cloud allows you to restore databases to the original location or to a new location.

Note

Due to technical limitations in Google Cloud, Veeam Backup for Google Cloud does not support restore to the original location if the source database is still present in the location.

How Database Restore Works

To restore a Cloud SQL database from an image-level backup, Veeam Backup for Google Cloud performs the following steps:

  1. Creates a temporary snapshot of the Cloud SQL instance that will host the restored database.

Note

If Veeam Backup for Google Cloud fails to restore the database, the Cloud SQL instance will be reverted to the temporary snapshot.

  1. Deploys a worker instance in the Google Cloud region in which the repository with backed-up data is located.
  2. Exports files, triggers and stored procedures of the processed database to the Temp folder of the storage bucket where the backup repository resides.

For more information on SQL dump files, see Google Cloud documentation.

  1. Imports the exported database files, triggers and stored procedures to the created Cloud SQL instance.
  2. Removes the worker instance from the Google Cloud environment.
  3. Deletes the temporary snapshot.

How to Perform Database Restore

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

  1. Launch the Database Restore wizard.
  2. Select databases.
  3. Choose a restore mode.
  4. Select a project.
  5. Configure target instance settings.
  6. Specify a restore reason.
  7. Finish working with the wizard.

Important

Before you start Cloud SQL database 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.