Back Up Data

CockroachDB offers the following methods to back up your cluster's data:

• cockroach dump, which is a CLI command to dump/export your database's schema and table data.
• BACKUP (enterprise license only), which is a SQL statement that backs up your cluster to cloud or network file storage.

Details

We recommend creating daily backups of your data as an operational best practice.

However, because CockroachDB is designed with high fault tolerance, backups are primarily needed for disaster recovery (i.e., if your cluster loses a majority of its nodes). Isolated issues (such as small-scale node outages) do not require any intervention.

Restore

For information about restoring your backed up data, see Restoring Data.

See Also

• Restore Data
• Use the Built-in SQL Client
• Other Cockroach Commands