Recovering from snapshots

A table can be restored from snapshot files with these simple steps:

1. TRUNCATE the table. This is necessary in the case of an accidental delete operation. If the snapshot files are restored without the table having been truncated, then the timestamp on the prevailing tombstone will still be more recent than anything saved via the snapshot process. Truncating the table ensures that the restored data takes precedence.

2. Copy the files from the most recent snapshot and backups directories into the table's data directory. Snapshot files are no different from normal SSTable files. Simply copy them into the data directory for your table. If you move your snapshots to another storage location, make sure you copy over ...

Get Mastering Apache Cassandra 3.x - Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.