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