Compliancemanzill.com
CIS Google Cloud Platform Foundation Benchmark v1.2.0

CIS Google Cloud Platform Foundation Benchmark v1.2.0/Cloud SQL Database Services/80 of 83

6.7Ensure that Cloud SQL database instances are configured with automated backups

Control family: Cloud SQL Database Services

Control description

It is recommended to have all SQL database instances set to enable automated backups.

How to implement

ResponsibilityCustomerYou configure and operate this in your own cloud accounts.

Automated backups let you restore a Cloud SQL instance after data is deleted, corrupted or encrypted by ransomware. Every instance has daily automated backups turned on, kept long enough to notice a problem before the last good copy expires.

Before you start

The same on every cloud, before the steps in the tabs.

  • Agree backup frequency, retention and the backup window for each instance, and how often restores are tested.

Evidence

  • The backup standard and the restore test schedule

On Google Cloud the tasks turn on automated backups for each instance in Cloud SQL, then watch with Security Command Center.

Task 1Turn on automated daily backups

  1. Sign in to the Google Cloud console at console.cloud.google.com and open SQL.
  2. Choose the instance and open Backups.
  3. Next to Settings, choose Edit.
  4. Select Automated daily backups, set Number of days to the agreed retention, and pick a Backup window outside busy hours.
  5. Choose Save.
  6. Check it: the next day, the Backups page lists a successful automated backup. Test a restore to a new instance at least once a year.

Task 2Keep it checked with the Security Health Analytics finding AUTO_BACKUP_DISABLED

  1. Open Security Command Center > Findings for the organization (Security Health Analytics runs on the Premium tier for most detectors).
  2. In the query editor, filter on category AUTO_BACKUP_DISABLED with state ACTIVE, and select Apply.
  3. Open each finding, read the resource and the explanation it gives, and turn on backups for the instance it names.
  4. Check it: after the next Security Health Analytics scan, no active AUTO_BACKUP_DISABLED finding remains.

Evidence

  • The Backups page of each instance, showing automated backups and recent successes
  • The record of the last restore test
  • Security Command Center, with no active AUTO_BACKUP_DISABLED finding

Console steps as of 5 November 2026. Not every step has been confirmed in a live console yet, and menus and labels can move between releases, so look for the nearest match if one has changed.