On-demand backups retention

[Eugene Z]

I was trying to find in the documents any mention of retention policies for on-demand backups for SQL Cloud instance; finding none assumed that the on-demand backups are retained unless removed.

But in our account all on-demand backups older than month were removed. This is completely unforeseen and we would like to

a) If possible to retrieve the older backups

b) Get to the bottom of it and understand/define retention policy for on-demand backups

Thanks much in advance!

Eugene 

[Fady (Google Cloud Platform)]

Hello Eugene,

According to this document, on-demand backups should persist until either you delete them, or until their instance is deleted. As you mentioned, it seems that not all on-demand backups show in the developers Console, but they can all be listed, described, and used to restore the instance by using these gcloud commands [1] [2] [3] in cloudshell or an authenticated SDK instance.

Example commands to list all backups and then use the ID listed to get a description of the backup:

$gcloud sql backups list --instance [INSTANCE]

$gcloud sql backups describe [ID] --instance=[INSTANCE]

There is already a feature request to improve the console’s list page at this link, but we can not provide an ETA or guarantee its implementation at the moment. Furthermore, if the first gcloud command above did not list the backups from more than a month ago, please open an issue tracker report for further investigation, and we will be happy to assist.