Nesta página, descrevemos o recomendador de aumento da retenção de backups do Cloud SQL, que ajuda a detectar instâncias críticas e que apresentam risco de perda de dados.
O recomendador de aumento da retenção de backup do Cloud SQL analisa os metadados da instância. Se a instância for de produção, tiver backups automatizados ativados e tiver menos de 21 backups retidos, recomendamos aumentar a retenção de backups.
To enable APIs, you need the Service Usage Admin IAM
role (roles/serviceusage.serviceUsageAdmin), which
contains the serviceusage.services.enable permission. Learn how to grant
roles.
No card Aumentar a confiabilidade da instância do Cloud SQL, clique em Ver tudo.
Selecione instâncias com a recomendação Aumentar a retenção de backups.
CLI da gcloud
Para listar as recomendações de aumento da retenção de backups usando a gcloud CLI, execute o comando gcloud recommender recommendations list conforme a seguir:
GET https://recommender.googleapis.com/v1/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 aumento da retenção de backups, 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 ver insights e recomendações detalhadas sobre instâncias
que precisam aumentar a retenção de backups usando o console Google Cloud ,
gcloud CLI ou a API Recommender.
Console
Para ver insights e recomendações detalhadas sobre instâncias que requerem o aumento da retenção de backups, 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 exigem o aumento da retenção de backup, execute o
comando gcloud recommender insights list
da seguinte maneira:
LOCATION: uma região em que suas instâncias estão localizadas, como us-central1.
API
Para conferir insights e recomendações detalhadas sobre instâncias que requerem o aumento da retenção de backups, use a API Recommendations e chame o método insights.list conforme a seguir:
GET https://recommender.googleapis.com/v1/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 implementar essa recomendação, faça o seguinte:
Para aumentar a retenção de backups:
Clique em Aumentar retenção de backups na coluna Problemas.
Uma janela Aumentar retenção de backups é exibida com uma recomendação.
Clique em Editar instância > Proteção de dados > Número de backups.
[[["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-11 UTC."],[],[],null,["\u003cbr /\u003e\n\n[MySQL](/sql/docs/mysql/recommender-increase-backup-retention \"View this page for the MySQL database engine\") \\| [PostgreSQL](/sql/docs/postgres/recommender-increase-backup-retention \"View this page for the PostgreSQL database engine\") \\| SQL Server\n\n\u003cbr /\u003e\n\n|\n| **Preview**\n|\n|\n| This feature is\n|\n| subject to the \"Pre-GA Offerings Terms\" in the General Service Terms section of the\n| [Service Specific Terms](/terms/service-terms#1).\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 increase backup retention [recommender](/recommender/docs/overview) which helps you detect instances which are critical and have a risk of data loss.\n\nThe Cloud SQL increase backup retention recommender analyzes instance metadata. If the instance is a production instance, has automated backups enabled, and has less than 21 retained backups, it is recommended to increase its backup retention.\n\nRecommendations are generated daily.\n\nPricing\n\nThe Cloud SQL increase backup retention recommender is in the *Standard* [Recommender pricing tier](/recommender/pricing).\n\nBefore you begin\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/sqlserver/project-access-control#roles).\n\n | Tasks | Roles |\n |-----------------------|------------------------------------------------------------------------------------------|\n | View recommendations | One of these roles: `recommender.cloudsqlViewer` or `cloudsql.viewer`. |\n | Apply recommendations | One of these roles: `recommender.cloudsqlAdmin`, `cloudsql.editor`, or `cloudsql.admin`. |\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 **Roles required to enable APIs**\n\n\n To enable APIs, you need the Service Usage Admin IAM\n role (`roles/serviceusage.serviceUsageAdmin`), which\n contains the `serviceusage.services.enable` permission. [Learn how to grant\n roles](/iam/docs/granting-changing-revoking-access).\n\n [Enable the API](https://console.cloud.google.com/flows/enableapi?apiid=recommender.googleapis.com)\n\nList reliability recommendations for increasing backup retention\n\nYou can list the increase backup retention recommendations by\nusing the Google Cloud console, [gcloud CLI](/sdk/gcloud), or the Recommender API. \n\nConsole\n\nTo list increase backup retention 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 **Increase backup retention** recommendation.\n\ngcloud CLI\n\nTo list increase backup retention 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=INCREASE_BACKUP_RETENTION\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\nAPI\n\nTo list increase backup retention recommendations using the\n[Recommendations API](/recommender/docs/using-api), call the\n[`recommendations.list`](/recommender/docs/reference/rest/v1/projects.locations.recommenders.recommendations/list)\nmethod as follows: \n\n```\nGET https://recommender.googleapis.com/v1/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 increase backup retention 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\nYou can view insights and detailed recommendations about instances\nthat require increasing their backup retention using the Google Cloud console,\n[gcloud CLI](/sdk/gcloud), or the Recommender API. \n\nConsole\n\nTo view insights and detailed recommendations about instances that require increasing their backup retention, click the recommendation link in the list of instances.\n\ngcloud CLI\n\nTo view insights and detailed recommendations about instances that require increasing their backup retention, 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_INSUFFICIENT_BACKUP_RETENTION\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\nAPI\n\nTo view insights and detailed recommendations about instances that require increasing their backup retention, use the\n[Recommendations API](/recommender/docs/using-api), call the\n[`insights.list`](/recommender/docs/reference/rest/v1/projects.locations.insightTypes.insights/list)\nmethod as follows: \n\n```\nGET https://recommender.googleapis.com/v1/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\nTo implement this recommendation, do the following:\n\n- To increase backup retention:\n\n 1. Click **Increase backup retention** in the **Issues** column. An **Increase backup retention** window displays providing a recommendation.\n 2. Click **Edit instance** \\\u003e **Data protection** \\\u003e **Number of backups**.\n\n For more information, see [Automated backup and transaction log retention](/sql/docs/sqlserver/backup-recovery/backups#retention).\n\nWhat's next\n\n- [Google Cloud recommenders](/recommender/docs/recommenders)\n- [About database observability](/sql/docs/sqlserver/observability)"]]
