Back up and restore databases using the Google Cloud console

You can use Google Cloud console to create, copy, and restore backups as well as monitor backup and restore operations.

You can select Backup/Restore from the left pane on the Instance Overview page to see all backups and operations in the instance, including backups of deleted databases.

Screenshot of Instance's Backup and Restore tab

When you select Backup/Restore from the Database Overview page, you can only see backups of that particular database.

Screenshot of the Database's Backup and Restore tab

Create a backup

  1. Go to the Instances page in the Google Cloud console.

    Go to the instances page

  2. Click on the instance that contains your desired backups or databases.

  3. Click the Backup/Restore menu item in the left pane.

  4. In the Backups table, click the Create button.

  5. Fill out the form and click the Create button.

  6. To check the progress of the operation, in the Spanner navigation menu, click the Operations tab. The Operations page shows a list of currently running operations.

  7. Find the Creating backup database-name operation in the list. If it's still running, a progress indicator in the End time column shows the percentage of the operation that is complete, as shown in the following image:

    Screenshot of progress indicator showing 0%

    If the operation takes too long, you can cancel it. For more information, see Cancel a long-running backup operation.

For more information about backups, see Create a backup.

Copy a backup

  1. Click the Backup/Restore menu item in the left pane.

  2. In the Backups table, select your desired backup and click the Copy button.

  3. Fill out the form by choosing a destination instance, providing a name, and selecting an expiration date for the backup copy.

  4. Click the Copy button.

  5. To check the progress of the operation, see the pop-up progress information, as shown in the following image:

    Screenshot of progress indicator showing 0 minutes 41 seconds

    If the operation takes too long, you can cancel it. For more information, see Cancel a long-running instance operation.

For more information, see Copy a backup.

Restore a database from a backup

  1. Click the Backup/Restore menu item in the left pane.

  2. In the Backups table, select your desired backup and click the Restore button.

  3. Fill out the form and click the Restore button.

  4. To check the progress of the operation, see the progress indicator, as shown in the following image:

    Screenshot of progress indicator showing 56%

  5. If the operation takes too long, you can cancel it. For more information, see Cancel a long-running instance operation.

For more information, see Restore from a backup.