Backup and restore
Active Classic databases automatically create backups at four-hour intervals, resulting in a total of six backups over a 24-hour period. At the end of each UTC day, the last successful four-hour interval backup becomes a daily backup.
The backup retention schedule is as follows:
-
DataStax retains four-hour interval backups for 24 hours on a rolling basis.
-
DataStax retains daily backups for 7 days on a rolling basis.
At any time, an active database can have up to 6 four-hour interval backups and 7 days of daily backups, for a total of 13 backups. This assumes the database is never suspended or hibernated and all backups are recorded successfully.
|
Hibernated and suspended databases do not record backups. A database that is hibernated or suspended for more than 7 consecutive days has no backups. You can’t restore data for deleted databases. Terminating a database destroys all associated data, including recorded backups, and prevents data recovery. |
Contact DataStax Support within 12 hours of an incident to recover data from a backup. DataStax recommends this window to ensure that there is an available backup of your data.
You must be able to verify that you are the Organization Administrator or Database Administrator for the database you are attempting to restore.
Restoration time varies based on a variety of factors. Communicate with Support to understand the scope and potential duration of your restoration.
When restoring data, you can do the following:
-
Restore data to the same database by replacing the current data with data from the backup. This overwrites any changes that occurred after the backup was recorded, including additions, removals, and edits.
-
Restore data to a new database with the same configuration as the original database, including database type, cloud provider, and region.
-
Restore one or more specific keyspaces and their tables from a backup.
For multi-region databases, backups are recorded only from the original region you selected when you created the database. When you restore a multi-region database from a backup, data is restored to the original region and then replicated to the additional regions.
