The Veeam Cookbook Series
A simple step by step no frills approach to achieving your goal
Recipe: Performing Google Cloud SQL Instance Restore to the original location
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.
- The original Cloud SQL instance has been removed more than 1 week ago.
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:
- Login the Veeam Backup for Google Cloud web interface.
- Navigate to Protected Data > Cloud SQL. Select the Cloud SQL instance that you want to restore, and click Restore > Instance Restore.
- 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.
- At the Restore Mode step , choose that you want to restore the selected Cloud SQL instance to the original location.
- At the Service Account step, select a service account with enough permissions to complete the restore operation. Click Next.
- 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 instance. Click Next.
- At the Summary step, review summary information and click Finish.
Links to Resources: