The Veeam Cookbook Series

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

Recipe: Performing Google Cloud SQL Database Restore

Expected deliverables:

An entire Google Cloud SQL database 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.
A Cloud SQL instance in the required project to host the restored database

Before you start: Veeam Backup for Google Cloud does not support restore to the original location if the source database is still present in the location. PostgreSQL databases can be restored only to PostgreSQL instances running the same database engine version

Assumptions:

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

Method:

Login the Veeam Backup for Google Cloud web interface.
Navigate to Protected Data > Cloud SQL. Select the Cloud SQL instance whose databases you want to restore, and click Restore > Database Restore.
At the Databases step, click Add to select databases to restore, and then choose a restore point that will be used to restore the selected databases (by default the most recent restore point). Click Next.
At the Project step, select a project where Cloud SQL instance to which you want to restore the selected databases is located, and a service account with proper privileges to complete the restore operation.
At the Instance step
- Click the link in the Instance field to choose a Cloud SQL instance that will host the restored databases, or leave the default to restore to the original instance.
- Specify a Cloud SQL account whose credentials will be used to perform the restore operation
At the Verification step, check all verifications are Passed, or double check the previous steps and pre-requisites in case of any warning or error.
At the Reason step, specify a reason for restoring the Cloud SQL databases. Click Next.
At the Summary step, review summary information and click Finish.

Links to Resources: