If you delete the commit logs you are rolling back to exactly what was in the snapshot. When you take a snapshot it flushes the memtables first, so there is nothing in the commit log that is not in the snapshot. Rolling back to a snapshot is rollback to that point in time. 

If you want to restore to any point in time you need snapshots + incremental snapshot + commit log (for things that have not made it to sstables). Otherwise there is a potential loss of data that has not been flushed to disk. This is different to what the DS docs are talking about. I'm not sure why they are saying delete the commit log, try asking on their forum http://www.datastax.com/support-forums/


Aaron Morton
Freelance Developer

On 2/05/2012, at 12:02 PM, Roshan wrote:

Any help regarding this is appreciated.

View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Cassandra-backup-queston-regarding-commitlogs-tp7508823p7518544.html
Sent from the cassandra-user@incubator.apache.org mailing list archive at Nabble.com.