Restoring a Google Cloud Spanner Database to a Different Location (Out of Place)

You can restore a Google Cloud Spanner database to a different location (out of place).

Procedure

1. From the Command Center navigation pane, go to Protect > Databases.

   The Databases page appears.

2. On the Instances tab, click the instance to change the access node for.

   The Instances page appears.

3. On the Database groups tab, for the database group that contains the database to restore, click the action button , and then click Backup history.

   The Job history page appears.

4. Click the backup job ID that you want to restore.

   The job ID page appears.

5. Click Restore.

   The Backup content page appears.

6. Select the database and then click Restore.

   The Restore options dialog box appears.

7. Select Out of place.

8. Select the cloud account.

9. In Instances, select the destination instance.

10. To override the existing user credential by another user credential, select Override credentials for restore, and then from the Credential list, select a user credential.

11. Specify to overwrite or merge data at the destination:

    • To overwrite the existing data with the backed up data, select Overwrite databases.

    • To merge the existing data with the backed up data, select Merge databases.

12. You can configure a schedule to repeat this restore operation. To create a schedule, do the following:

    1. Click Schedule.

       The Add schedule dialog box appears.

    2. In the Name box, type a name for the schedule.

    3. Configure the Frequency and Repeat parameters.

    4. To specify exceptions to the schedule, click Exceptions.

       The Exceptions dialog box appears.

    5. Configure the exception parameters:

       • You can click Add Exception to save a set of exception parameters and continue adding sets of exception parameters.

       • Click Save when you have finished configuring the exception parameters.

    6. Under the Range of recurrence section, specify the Start date and End date to schedule the recurrence range of the restore operation.

    7. To save the schedule and return to the restore dialog box, click Schedule.

13. Click Submit.