Can you backup every 10 minutes (your maximum tolerable data loss)?

  • Yes, up to 10 minutes of data loss, as the db backups (e.g. .bak file in SQL Server) writes out to cloud storage every 10 minutes.

Backups of your Cloud SQL Instance

Upto 7 backups are stored by default (you only pay for the storage approx 0.17/GB/month)

No egress charges as long as backups are in the same region

Default backup window is 4 hours, but can be manually triggered

gcloud sql backups create --async --instance MY_SQL_INSTANCE_NAME

Restores of your Cloud SQL Instance

gcloud sql backups list --instance MY_INSTANCE_NAME
gcloud sql backups restore ID_of_INSTANCE --restore-instance=RESTORE_INSTANCE_NAME




Need an experienced Cloud Networking or a Cloud Data Protection Expert?  Anuj has successfully delivered over a dozen deployments on each of the public clouds (AWS/GCP/Azure) including several DevSecOps engagements. Set up a time with Anuj Varma.