# Excessive Automated Backup Retention in Cloud SQL

Canonical: https://www.pointfive.co/efficiency-hub/inefficiencies/excessive-automated-backup-retention-in-cloud-sql

[Cloud Efficiency Hub](https://www.pointfive.co/efficiency-hub) 

# Excessive Automated Backup Retention in Cloud SQL

## Explanation

This inefficiency occurs when automated Cloud SQL backups are retained longer than required by recovery objectives or governance needs. Because backups accumulate over the retention window (and can grow quickly for high-change databases), excessive retention drives ongoing backup storage charges without improving practical recoverability.

## Relevant Billing Model

Cloud SQL bills for backup storage ("Backups (used)") based on stored backup data over time. Longer retention increases stored backup volume and cost.

## Detection

- Review whether automated backup retention periods exceed documented recovery requirements

- Assess whether the retained window provides meaningful operational recovery value versus "just in case" storage

- Identify databases with high change rates where extended retention materially increases stored backup volume

## Remediation

- Reduce automated backup retention to the minimum that meets recovery and governance requirements

- Use a separate long-term retention approach for audit/compliance needs instead of extending operational backup retention indefinitely

## Relevant Documentation

[https://cloud.google.com/sql/pricing](https://cloud.google.com/sql/pricing)

[https://docs.cloud.google.com/sql/docs/mysql/backup-recovery/backups](https://docs.cloud.google.com/sql/docs/mysql/backup-recovery/backups)

[Submit Feedback](https://hub.pointfive.co/inefficiencies/excessive-automated-backup-retention-in-cloud-sql)

## At a glance

Reference

CER-0279

Cloud provider

GCP

Service

Cloud SQL

Category

[Databases](https://www.pointfive.co/efficiency-hub/service-category/databases)

Inefficiency type

Excessive Data Retention

## Contributed by

- Hierony Manurung 

### Hierony Manurung

Cloud FinOps @ Dkatalis

[LinkedIn](https://www.linkedin.com/in/hierony-manurung-53598168)

---
Source: the public page above. Product screenshots and illustrative interfaces are examples, not live customer data.