Diagram
A horizontal timeline showing a Cloud SQL backup as base copy, continuous transaction logs, a PITR timestamp before an error, and a replay arrow creating a new instance.
Cloud SQL Point-in-Time Recovery With Transaction Logs
Cloud SQL point-in-time recovery recovers an instance to a specific point in time by applying transaction logs, also called binary logs, on top of a backup. A point-in-time recovery in Cloud SQL always creates a new instance, and the recovery cannot be performed to an existing instance. Because the new instance starts from stored configuration and replayed data, the original instance remains unchanged while the recovered copy can be verified before switching traffic.
Successful Cloud SQL recovery depends on retaining both backups and logs:
Domain 5 of 7
24 practice questions
Practice this DomainLast updated