Do same‑instance Cloud SQL restores preserve IAM bindings and custom flags?
0 reputation · 20 Jul 2022, 05:54 UTC
Goal
Determine whether a point‑in‑time restore performed on a Cloud SQL instance keeps the instance’s IAM policies and custom flags, or if those settings are overwritten by the backup metadata.
Constraints
The restore operation locks the instance for the duration of the process, causing a temporary loss of connectivity. The backup snapshot contains only database files and the initial configuration, but it is unclear if it propagates instance‑level settings such as IAM bindings, flags, or networking options.
Unresolved Questions
Which instance‑level properties are retained after a same‑instance restore, and which ones must be re‑applied manually? How can a user verify that the restored data matches the source without relying on external checksum tools? What is the recommended workflow to confirm that IAM bindings and custom flags remain unchanged after the operation?
gcp