SQL database instance automated backups should be enabled

Description

SQL database instances should be configured to be automatically backed up. Backups enable a Cloud SQL instance to recover lost data or to recover from a problem with that instance.

Remediation Steps

Google Cloud Console

  • Navigate to Cloud SQL instances.

  • Click on the Cloud SQL database instance name to go to the Overview page.

  • Click Backups in the left navigation pane.

  • Click Edit next to Settings.

  • Check the Automate backups checkbox.

  • Choose a window of time for your data to be automatically backed up.

  • Click Save.

gcloud CLI

  • Schedule an automated backup for each Cloud SQL database instance:

    • gcloud sql instances patch INSTANCE_NAME --backup-start-time HH:MM