Nesta página, descrevemos o recomendador de ativação de backups automatizados do Cloud SQL, que ajuda a detectar instâncias críticas e que apresentam risco de perda de dados.
O recomendador de ativação de backups automatizados do Cloud SQL analisa os metadados da instância e recomenda a configuração de backups automatizados para instâncias de produção que não têm backups automatizados ativados.
No card Aumentar a confiabilidade da instância do Cloud SQL, clique em Ver tudo.
Selecione instâncias com a recomendação Ativar backups automatizados.
CLI da gcloud
Para listar as recomendações de ativação de backups automatizados usando a gcloud CLI, execute o comando gcloud recommender recommendations list conforme a seguir:
GET https://recommender.googleapis.com/v1beta1/projects/PROJECT-ID/locations/LOCATION/recommenders/google.cloudsql.instance.ReliabilityRecommender/recommendations
Substitua:
PROJECT_ID: o ID do projeto.
LOCATION: uma região em que suas instâncias estão localizadas, como us-central1.
Se o recomendador detectar instâncias para a recomendação de ativação de backups automatizados, elas serão listadas em uma tabela. Cada linha mostra o nome da instância, uma breve recomendação, o tipo de máquina atual, o tipo de máquina recomendado, o local e a data da última atualização.
Ver insights e recomendações detalhadas
É possível acessar insights e recomendações detalhadas sobre instâncias
que precisam ativar backups automatizados usando o console Google Cloud ,
gcloud CLI ou a API Recommender.
Console
Para acessar insights e recomendações detalhadas sobre instâncias que exigem a ativação de backups automatizados, clique no link de recomendação na lista de instâncias.
CLI da gcloud
Para ver insights e recomendações detalhadas sobre instâncias que requerem a ativação de backups automatizados, execute o comando gcloud recommender insights list conforme a seguir:
LOCATION: uma região em que suas instâncias estão localizadas, como us-central1.
API
Para acessar insights e recomendações detalhadas sobre instâncias que requerem a ativação de backups automatizados, use a API Recommendations e chame o método insights.list conforme a seguir:
GET https://recommender.googleapis.com/v1beta1/projects/PROJECT-ID/locations/LOCATION/insightTypes/google.cloudsql.instance.ReliabilityInsight/insights
Substitua:
PROJECT_ID: o ID do projeto.
LOCATION: uma região em que suas instâncias estão localizadas, como us-central1.
Aplicar recomendação
Para aplicar essa recomendação, faça o seguinte:
Clique em Ativar backups automáticos na coluna Problemas.
A janela Ativar backups automatizados vai aparecer com uma recomendação.
Clique em Editar instância > Proteção de dados > Automatizar backups diários para continuar.
[[["Fácil de entender","easyToUnderstand","thumb-up"],["Meu problema foi resolvido","solvedMyProblem","thumb-up"],["Outro","otherUp","thumb-up"]],[["Difícil de entender","hardToUnderstand","thumb-down"],["Informações incorretas ou exemplo de código","incorrectInformationOrSampleCode","thumb-down"],["Não contém as informações/amostras de que eu preciso","missingTheInformationSamplesINeed","thumb-down"],["Problema na tradução","translationIssue","thumb-down"],["Outro","otherDown","thumb-down"]],["Última atualização 2025-09-04 UTC."],[],[],null,["# Prevent data loss for your instance by enabling automated backups\n\n\u003cbr /\u003e\n\n[MySQL](/sql/docs/mysql/recommender-enable-automated-backups \"View this page for the MySQL database engine\") \\| PostgreSQL \\| [SQL Server](/sql/docs/sqlserver/recommender-enable-automated-backups \"View this page for the SQL Server database engine\")\n\n\u003cbr /\u003e\n\n|\n| **Preview**\n|\n|\n| This feature is subject to the \"Pre-GA Offerings Terms\" in the General Service Terms section\n| of the [Service Specific Terms](/terms/service-terms#1).\n|\n| You can process personal data for this feature as outlined in the\n| [Cloud Data Processing\n| Addendum](/terms/data-processing-addendum), subject to the obligations and restrictions described in the agreement under\n| which you access Google Cloud.\n|\n| Pre-GA features are available \"as is\" and might have limited support.\n|\n| For more information, see the\n| [launch stage descriptions](/products#product-launch-stages).\n\nThis page describes the Cloud SQL enable automated backups [recommender](/recommender/docs/overview) which helps you detect instances which are critical and have a risk of data loss.\n\nThe Cloud SQL enable automated backups recommender analyzes instance metadata and recommends to configure automated backups for production instances that have no automated backups enabled.\n\nRecommendations are generated daily.\n\nPricing\n-------\n\nThe Cloud SQL enable automated backups recommender is in the *Standard* [Recommender pricing tier](/recommender/pricing).\n\nBefore you begin\n----------------\n\nBefore you can view recommendations and insights, do the following:\n\n- To get the permissions to view and work with insights and recommendations, ensure that you have the required [Identity and Access Management (IAM) roles](/sql/docs/postgres/project-access-control#roles).\n\n For more information about IAM roles, see [IAM basic and predefined roles reference](/iam/docs/understanding-roles) and [Manage access to projects, folders, and organizations](/iam/docs/granting-changing-revoking-access).\n-\n\n\n Enable the Recommender API.\n\n\n [Enable the API](https://console.cloud.google.com/flows/enableapi?apiid=recommender.googleapis.com)\n\nList reliability recommendations for enabling automated backups\n---------------------------------------------------------------\n\nYou can list the enable automated backups recommendations by\nusing the Google Cloud console, [gcloud CLI](/sdk/gcloud), or the Recommender API. \n\n### Console\n\nTo list enable automated backups recommendations using the\nGoogle Cloud console, follow these steps:\n\n1. Go to the **Recommendation Hub**.\n\n [Go to the Recommendation Hub](https://console.cloud.google.com/home/recommendations/)\n\n For more information, see\n [Getting started with Recommendation Hub](/recommender/docs/recommendation-hub/identify-configuration-problems).\n2. In the **Increase Cloud SQL instance reliability** card, click **View all**.\n\n3. Select instances with the **Enable automated backups** recommendation.\n\n### gcloud CLI\n\nTo list enable automated backups recommendations using gcloud CLI, run the\n[`gcloud recommender recommendations list`](/sdk/gcloud/reference/recommender/recommendations/list)\ncommand as follows: \n\n```\ngcloud recommender recommendations list \\\n--project=PROJECT_ID \\\n--location=LOCATION \\\n--recommender=google.cloudsql.instance.ReliabilityRecommender \\\n--filter=recommenderSubtype=ENABLE_AUTO_BACKUP\n\n```\n\nReplace the following:\n\n- \u003cvar translate=\"no\"\u003ePROJECT_ID\u003c/var\u003e: Your project ID.\n- \u003cvar translate=\"no\"\u003eLOCATION\u003c/var\u003e: A region where your instances are located, such as `us-central1`.\n\n### API\n\nTo list enable automated backups recommendations using the\n[Recommendations API](/recommender/docs/using-api), call the\n[`recommendations.list`](/recommender/docs/reference/rest/v1beta1/projects.locations.recommenders.recommendations/list)\nmethod as follows: \n\n```\nGET https://recommender.googleapis.com/v1beta1/projects/PROJECT-ID/locations/LOCATION/recommenders/google.cloudsql.instance.ReliabilityRecommender/recommendations\n```\n\nReplace the following:\n\n- \u003cvar translate=\"no\"\u003ePROJECT_ID\u003c/var\u003e: Your project ID.\n- \u003cvar translate=\"no\"\u003eLOCATION\u003c/var\u003e: A region where your instances are located, such as `us-central1`.\n\nIf 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.\n\nView insights and detailed recommendations\n------------------------------------------\n\nYou can view insights and detailed recommendations about instances\nthat require enabling automated backups using the Google Cloud console,\n`gcloud CLI`, or the Recommender API. \n\n### Console\n\nTo view insights and detailed recommendations about instances that require enabling automated backups, click the recommendation link in the list of instances.\n\n### gcloud CLI\n\nTo view insights and detailed recommendations about instances that require enabling automated backups, run the\n[`gcloud recommender insights list`](/sdk/gcloud/reference/recommender/insights/list)\ncommand as follows: \n\n```\ngcloud recommender insights list \\\n--project=PROJECT-ID \\\n--location=LOCATION \\\n--insight-type=google.cloudsql.instance.ReliabilityInsight \\\n--filter=insightSubtype=CRITICAL_INSTANCE_AUTO_BACKUP_NOT_ENABLED\n```\n\nReplace the following:\n\n- \u003cvar translate=\"no\"\u003ePROJECT_ID\u003c/var\u003e: Your project ID.\n- \u003cvar translate=\"no\"\u003eLOCATION\u003c/var\u003e: A region where your instances are located, such as `us-central1`.\n\n### API\n\nTo view insights and detailed recommendations about instances that require enabling automated backups, use the\n[Recommendations API](/recommender/docs/using-api), call the\n[`insights.list`](/recommender/docs/reference/rest/v1beta1/projects.locations.insightTypes.insights/list)\nmethod as follows: \n\n```\nGET https://recommender.googleapis.com/v1beta1/projects/PROJECT-ID/locations/LOCATION/insightTypes/google.cloudsql.instance.ReliabilityInsight/insights\n```\n\nReplace the following:\n\n- \u003cvar translate=\"no\"\u003ePROJECT_ID\u003c/var\u003e: Your project ID.\n- \u003cvar translate=\"no\"\u003eLOCATION\u003c/var\u003e: A region where your instances are located, such as `us-central1`.\n\nApply recommendation\n--------------------\n\nTo apply this recommendation, do the following:\n\n- Click **Enable automated backups** in the **Issues** column. An **Enable automated backups** window displays providing a recommendation.\n- Click **Edit instance** \\\u003e **Data Protection** \\\u003e **Automate daily backups** to proceed.\n\n For more information, see [Automated backup and transaction log retention](/sql/docs/postgres/backup-recovery/backups#automated-backups).\n\nWhat's next\n-----------\n\n- [Google Cloud recommenders](/recommender/docs/recommenders)\n- [About database observability](/sql/docs/postgres/observability)"]]
