Perform a Test Backup and Restore for CockroachDB

You can perform a test backup and restore to verify that the CockroachDB cluster is set up correctly.

Back Up the Cluster

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

    The Big data page appears.

  2. Click the cluster instance.

    The cluster page appears.

  3. In the upper-right corner of the page, click Back up.

    The Backup dialog box appears.

  4. Select one of the following backup levels:

    • Full

    • Incremental

  5. Click SUBMIT.

Restore the Cluster

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

    The Big data page appears.

  2. Click the cluster instance.

    The cluster page appears.

  3. In the upper-right corner of the page, click Restore.

    The Restore 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 name to restore it as a different entity.

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

    5. 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 is 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 is restored as a database or table of the cluster.

    5. Click Restore.

×

Loading...