Backup and restore

Create backups and restore your data

Backup and restoration is the process of creating and storing copies of your data for protection against data loss. With a proper backup strategy, you can always restore your data to a most-recent known working state and minimize application downtime. This in turn guarantees business and application continuity.

Unlike traditional single-instance databases, YugabyteDB is designed for fault tolerance. By maintaining at least three copies of your data across multiple data regions or multiple clouds, it makes sure no losses occur if a single node or single data region becomes unavailable. Thus, with YugabyteDB, you would mainly use backups to:

• Recover from a user or software error, such as accidental table removal.
• Recover from a disaster scenario, like a full cluster failure or a simultaneous outage of multiple data regions. Even though such scenarios are extremely unlikely, it's still a best practice to maintain a way to recover from them.
• Maintain a remote copy of data, as required by data protection regulations.

Export and import

Export and import data using SQL or CQL scripts.

Distributed snapshots

Back up and restore data using distributed snapshots.

Point-in-time recovery

Restore data to a particular point in time.