Size of Cloud SQL Backup

[cypher115]

Hi, Google Cloud Community!

Is there a way to check backups size of CloudSQL DB?
We're trying to estimate and anticipate Cloud SQL costs. Even if we can use the GCP Calculator - we'd still be unsure of the exact backup size we'd used. 

Thank you.

[DamianS]

Hello @cypher115 ,


AFAIK, this is only possible, when you set the backup-location to custom ( like for example Cloud Bucket ). Basically, each CloudSQL backup is incremental, so the first one should be similar in size with your DB. However, if you delete your first backup, next one will be full backup ( with similar size to your SQL instance). So the solution might be to set retention policy to remove first full backup after specified amount of time  and take full backup after deletion ( so you will be able to estimate somehow your backup size). 

cheers,
DamianS