Overview of restoring an instance

This page provides information you should know before restoring an instance from a backup or performing a point-in-time recovery (PITR).

For step-by-step instructions for performing a restore or point-in-time recovery, see * Restoring an instance. * Point-in-time recovery.

General tips about performing a restore

When you restore an instance from a backup, whether to the same instance or to a different instance, keep in mind the following items:

  • The restore operation overwrites all data on the target instance.
  • The target instance is unavailable for connections during the restore operation; existing connections are lost.
  • If you are restoring to an instance with read replicas, you must delete all replicas and recreate them after the restore operation completes.
  • The restore operation restarts the instance.

Tips and requirements for restoring to a different instance

When you are restoring a backup to a different instance, keep in mind the following restrictions and best practices:

  • You cannot restore an instance using a backup taken from an instance with a different generation (First Generation or Second Generation).

  • The target instance should have the same database version and edition as the instance from which the backup was taken.

    If you want to upgrade the database version for your instance, follow the steps in Upgrading the Database for an Instance.

  • The storage capacity of the target instance must be at least as large as the capacity of the instance being backed up. The amount of storage being used does not matter. You can see the storage capacity of the instance in the console Cloud SQL instances page

  • The target instance must be in the RUNNABLE state.

  • The target instance can be a different tier or machine type than the instance from which the backup was taken.

What's next