Hi @agnes,
To answer your question, GCP does automatically back up databases. But these backups are only kept for a set period, which you can configure. This period is meant to balance how long you need backups with storage costs.
If you're looking for a backup that's older than the retention period you've set, it probably won't be available through the database's restore feature. GCP automatically deletes older backups to save space.
To keep backups longer, I recommend exporting them to Cloud Storage. It's built for long-term storage, and you can set policies to decide how long backups stay there. This way, you can still access older backups even after they're gone from the database service.
Was this helpful? If so, please accept this answer as “Solution”. If you need additional assistance, reply here within 2 business days and I’ll be happy to help.
LinkedIn
Twitter
