The Veeam Cookbook Series

A simple step by step no frills approach to achieving your goal

Recipe: Performing Google Cloud SQL Instance Restore

Expected deliverables:

An entire Google Cloud SQL instance recovered at the time of backup state.

Time to complete: 5 minutes

Ingredients:

• A Google Cloud SQL backup
• A Worker Configuration in the same region in which the repository with backed-up data is located, if restoring from an image-level backup.

Before you start: 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.

Assumptions:

You have an existing Veeam Backup for Google Cloud deployment, and backups of one or more Google Cloud SQL databases.

Method:

1. Login the Veeam Backup for Google Cloud web interface.
2. Navigate to Protected Data > Cloud SQL. Select the Cloud SQL instance that you want to restore, and click Restore > Instance Restore.
3. At the Instances step, select a restore point that will be used to restore the selected Cloud SQL instance (by default the most recent restore point). Click Next.
4. At the Restore Mode step , choose whether you want to restore the selected Cloud SQL instance to the original or to a custom location. If you choose to restore to the origial location, you can go directly to step 11 in this recipe.
5. At the Project step, select a project where the restored Cloud SQL instance will be created. Click Check Permissions to validate that the service account used has all the necessary permissions.
6. At the Region step, select a region and an availability zone where the restored Cloud SQL instance will operate.
7. At the Instance Settings step, select each Cloud SQL instance to be restored and click Edit if you want to change the name and/or the machine type.
8. At the Network Settings step, select the Cloud SQL instance to be restored and click Edit.
   • Choose whether you want to configure public IP and private IP connectivity for the restored Cloud SQL instance.
   • For private IP you must specify a VPC network to which the instance will be connected
   • For public IP you must use the Allowed network connections section to specify the allowed IP address ranges
9. At the Security Settings step, select the Cloud SQL instance and click Edit.
   • Choose whether the restored Cloud SQL instance will be encrypted with customer-managed encryption keys (CMEKs) or will keep the original encryption scheme (default).
   • If you want to secure connections to the restored Cloud SQL instance, set the Allow only SSL connections toggle to On.
10. At the Flags step, you can instruct Veeam to modify flags set on databases of the restored Cloud SQL instance. Leave the default and click next.
11. At the Reason step, specify a reason for restoring the Cloud SQL instance. Click Next.
12. At the Summary step, review summary information and click Finish.

Links to Resources:

• Veeam Guides and Helpcenter
• Veeam Community Forums

---