V11 SP8

Performing an Out-of-Place Cassandra Restore

Perform a restore of the Cassandra keyspace or column family to a new Cassandra cluster.

The destination instance can have any of the following configurations:

  • The same number of nodes as the source
  • Fewer number of nodes than the source
  • A larger number of nodes than the source

If the number of nodes on the source and destination do not match, then you can set the same target node to multiple source nodes.

When you select the option to use the bulk load, you must provide a path that has enough free space to hold the keyspaces. The software automatically creates the path when it performs the restore.

When incremental backs are enabled on Cassandra, the Cassandr

If you enabled incremental backups on the Cassandra cluster, then during the restore the Cassandra software might create files in the backup directory. If you disable incremental backups before the restore, then you can reduce the space that the files used and reduce the application size of the next incremental backup.

Before You Begin


  1. From the CommCell Browser, expand Client Computers > client > Distributed Apps > instance.
  2. Right-click the default_subclient, and then click Browse and Restore.
  3. On the Browse and Restore Options dialog box, select the restore options.
    • To restore the latest backup, select Latest Backup.
    • To restore to a point-in-time, select Time Range, and then type the date and time in the Start and End boxes.
  4. Click View Content.
  5. On the Browse page, determine what data to restore.

    The Browse page displays all the cluster nodes in the left pane.

    1. Expand the nodes to view the keyspaces, and the ColumFamily entities that keyspace contains.
    2. To include data from all the nodes in the restore, perform the following operations:
      • For a keyspace, right-click the keyspace, and then click Select Keyspace from all nodes.
      • For a ColumnFamily, right-click the ColumnFamily, and then click Select ColumnFamily from all nodes.
    3. Click Recover All Selected.

      The Restore Options dialog box appears.

  6. On the General tab, select the restore options:
    1. Select the Out of place restore check box.
    2. From the Destination Instance list, select the new Cassandra instance.
    3. Set the target for the source nodes.

      The software restores the data from one or more source nodes to the target node.

      You must set the target for every node.

      Option Steps
      Set a source node to a unique target In the row for the source, from the Target list, select the node.
      Set multiple source nodes to the same target
      1. In the Source column, select the nodes to set to the same target, and then click Set Target.

        The Select Target dialog box appears.

      2. From the Select Target list, select the node, and then click OK.
    4. Select the Use SSTableLader Tool check box.

      When you select this option, you must provide a path in the Staging Location box.

    5. Select the database recover option.
      • To have the software recover the database, select Recover.
      • To have the Commvault software restore the database files for the selected keyspaces/ColumnFamily to the staging path and to prevent the software from recovering the database after the restore, select Do Not Recover.
    6. In the Staging Location box, type the full path to the staging location.
    7. In the Number of Streams box, type the number of streams the software uses for the restore operation.
  7. Click OK.


The software restores the data. If you chose Do Not Recover, you must manually run sstableloader after the restore completes, to recover the database.

What to Do Next

If you disabled incremental backups, use the following command to enable them:

nodetool enablebackup