Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

GCP Automatic Backup

In Cloud SQL GCP automatic backup means, Does its take a snapshot of the instance or really takes a backup of the database. For the SQL server, I am not seeing any backup history corresponding to the user database.

0 1 401
1 REPLY 1

In case you delete an instance, the data is preserved for 4 days. See.

If you have not set On-demand backups, only seven automated backups are retained (seven is the minimum and the default, you can set it higher, see). Automated Backups get pruned regularly due to the cost and size of retaining backups. Unfortunately, this means that the currently visible backups are the only automated backups you can restore from.

On-demand backups are not automatically deleted the way automated backups are. See.

To keep backups indefinitely, you can create an on-demand backup, as they are not deleted in the same way as automated backups. On-demand backups remain indefinitely. That is, they remain until they're deleted or the instance they belong to is deleted. Because that type of backup is not deleted automatically, it can affect billing.