SQL database instance automated backups should be enabled¶
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.
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.
Schedule an automated backup for each Cloud SQL database instance:
gcloud sql instances patch INSTANCE_NAME --backup-start-time HH:MM