Prevent data loss for your instance by enabling automated backups
Preview
This feature is subject to the "Pre-GA Offerings Terms" in the General Service Terms section of theService Specific Terms. You can process personal data for this feature as outlined in theCloud Data Processing Addendum, subject to the obligations and restrictions described in the agreement under which you access Google Cloud. Pre-GA features are available "as is" and might have limited support. For more information, see thelaunch stage descriptions.
This page describes the Cloud SQL enable automated backupsrecommender which helps you detect instances which are critical and have a risk of data loss.
The Cloud SQL enable automated backups recommender analyzes instance metadata and recommends to configure automated backups for production instances that have no automated backups enabled.
Recommendations are generated daily.
Pricing
The Cloud SQL enable automated backups recommender is in theStandardRecommender pricing tier.
Before you begin
Before you can view recommendations and insights, do the following:
- To get the permissions to view and work with insights and recommendations,ensure that you have the requiredIdentity and Access Management (IAM) roles.
For more information about IAM roles, seeIAM basic and predefined roles reference andManage access to projects, folders, and organizations.Tasks Roles View recommendations One of these roles: recommender.cloudsqlViewerorcloudsql.viewer.Apply recommendations One of these roles: recommender.cloudsqlAdmin,cloudsql.editor, orcloudsql.admin. Enable the Recommender API.
List reliability recommendations for enabling automated backups
You can list the enable automated backups recommendations byusing the Google Cloud console,gcloud CLI, or the Recommender API.
Console
To list enable automated backups recommendations using theGoogle Cloud console, follow these steps:
Go to theRecommendation Hub.
For more information, seeGetting started with Recommendation Hub.
In theIncrease Cloud SQL instance reliability card, clickView all.
Select instances with theEnable automated backups recommendation.
gcloud CLI
To list enable automated backups recommendations using gcloud CLI, run thegcloud recommender recommendations listcommand as follows:
gcloud recommender recommendations list \--project=PROJECT_ID \--location=LOCATION \--recommender=google.cloudsql.instance.ReliabilityRecommender \--filter=recommenderSubtype=ENABLE_AUTO_BACKUP
Replace the following:
PROJECT_ID: Your project ID.LOCATION: A region where your instances are located, such asus-central1.
API
To list enable automated backups recommendations using theRecommendations API, call therecommendations.listmethod as follows:
GET https://recommender.googleapis.com/v1beta1/projects/PROJECT-ID/locations/LOCATION/recommenders/google.cloudsql.instance.ReliabilityRecommender/recommendations
Replace the following:
PROJECT_ID: Your project ID.LOCATION: A region where your instances are located, such asus-central1.
If the recommender detects instances for the enable automated backups recommendation, it lists them in a table. Each row shows the instance name, a brief recommendation, the current machine type, the recommended machine type, the location, and the last refresh date.
View insights and detailed recommendations
You can view insights and detailed recommendations about instancesthat require enabling automated backups using the Google Cloud console,gcloud CLI, or the Recommender API.
Console
To view insights and detailed recommendations about instances that require enabling automated backups, click the recommendation link in the list of instances.
gcloud CLI
To view insights and detailed recommendations about instances that require enabling automated backups, run thegcloud recommender insights listcommand as follows:
gcloud recommender insights list \--project=PROJECT-ID \--location=LOCATION \--insight-type=google.cloudsql.instance.ReliabilityInsight \--filter=insightSubtype=CRITICAL_INSTANCE_AUTO_BACKUP_NOT_ENABLED
Replace the following:
PROJECT_ID: Your project ID.LOCATION: A region where your instances are located, such asus-central1.
API
To view insights and detailed recommendations about instances that require enabling automated backups, use theRecommendations API, call theinsights.listmethod as follows:
GET https://recommender.googleapis.com/v1beta1/projects/PROJECT-ID/locations/LOCATION/insightTypes/google.cloudsql.instance.ReliabilityInsight/insights
Replace the following:
PROJECT_ID: Your project ID.LOCATION: A region where your instances are located, such asus-central1.
Apply recommendation
To apply this recommendation, do the following:
- ClickEnable automated backups in theIssues column. AnEnable automated backups window displays providing a recommendation.
ClickEdit instance >Data Protection >Automate daily backups to proceed.
For more information, seeAutomated backup and transaction log retention.
What's next
Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-07-14 UTC.