Google Cloud Platform for Developers

Point-in-time recovery

In addition to standard recovery from backups, Cloud SQL supports point-in-time recovery. As the name implies, this makes it possible to restore a database to a specific point in time. Point-in-time recovery requires that both automated backups and binary logging are enabled for your instance.

There are some limitations to point-in-time recovery. Binary logging will decrease the write performance of your instance, and point-in-time recovery may only be used to create a new Cloud SQL instance. The new instance will have the same settings as the original instance, similar to if the instance was cloned.