Restoring CockroachDB Cluster

You can restore CockroachDB Cluster to a same or different cluster instance. The full cluster restore can only be performed on a cluster without user created tables or databases.

Restore the Cluster

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

   The Big data page appears.

2. Click CockroachDB, and then click a cluster instance.

   The cluster page appears.

3. In the row form the cluster, click the action button , and then click Restore.

   The Backup content page appears.

4. If you want to restore either database(s) or table(s) of the cluster, complete the following:

   1. Select either cluster, database(s) or table(s) as per requirement, and then click restore.

      The Restore options dialog box appears.

   2. From the Destination Cluster list, select the same cluster instance for in-place or a different cluster instance for out of place cluster restore.

   3. In Database details section, you can change the destination database or table name to restore it as a different entity.

   4. To restore an incremental backup job (table, database, cluster) up to a particular point in time, use the Point in time option.

      You can either select a date from the calendar or specify the end date of the backup using the Latest backup time option.

   5. To overwrite the existing database or tables of the cluster, select the Unconditionally overwrite if it already exists check box.

   6. Click Restore.

5. If you want to restore the full cluster, complete the following:

   1. Select the full cluster by selecting the checkbox located on the left side of the Name column, and then click restore.

      The Restore options dialog box appears.

   2. From the Destination Cluster list, select the same cluster instance for in-place or a different cluster instance for out of place cluster restore.

   3. The Full cluster restore checkbox is selected by default.

      Note

      If you deselect the Full cluster restore checkbox, it will be restored as a database.

   4. Select Unconditionally overwrite if it already exists checkbox to replace the existing cluster with the current one.

      Note

      When you select Unconditionally overwrite if it already exists checkbox, the Full cluster restore checkbox is deselected and it will be restored as a database or table of the cluster.

   5. Click Restore.