Skip to main content

Backup and restore overview

NineData backup and restore helps protect cloud and self-managed databases with logical backup, physical backup, restore, and backup-data query workflows. Use it to support disaster recovery, point-in-time validation, and long-term data protection across multiple environments.

Background​

Data security is essential for business continuity and customer trust. Network attacks, operational mistakes, and application bugs can all put production data at risk.

NineData uses cloud-native infrastructure to provide durable backup storage, restore workflows, and online backup-data query. These capabilities help teams recover data, verify historical changes, and reduce the operational effort required to maintain backup systems.

Features​

FunctionDescription
Backup
  • Logical backup: Backs up database objects, such as tables and indexes. Supported backup types include full backup, incremental backup, and schema backup.
  • Physical backup: Backs up database files.
RestoreSupports restore from logical backup sets and physical backup sets. Logical backup sets support second-level RPO and fine-grained row-level recovery.
Online query of backup dataSupports online SQL queries for data in logical backup sets. For details, see Query backup data.

Advantages​

NineData backup and restore is based on cloud-native architecture and provides the following advantages:

  • Ready to use: Create an account and start protecting data without building a separate backup system.
  • Simple configuration: Use guided console workflows instead of maintaining complex backup infrastructure.
  • Multi-environment support: Protect databases in public cloud, private cloud, hybrid cloud, and self-managed environments through public or private network access.
  • Security and compliance: Configure backup frequency, backup cycle, and retention period. NineData supports remote backup, hot and cold backup, backup data encryption, and encrypted data transmission.
  • High availability: Backup storage uses redundant copies and cross-region or cross-availability-zone disaster recovery capabilities provided by cloud vendors.
  • Second-level RPO: By monitoring and backing up database change logs in real time, NineData can provide RPO close to the second level.
  • Online backup-data query: Query backup data at a specified point in time and use the result to support recovery after data loss.

Typical use cases​

  • Self-managed database backup in the cloud: Back up self-managed cloud databases to reduce infrastructure maintenance effort and improve data protection.
  • Local database backup: Back up local databases to cloud storage to reduce local storage pressure as data grows.
  • Multi-cloud or multi-region backup: Store backup data across regions or cloud vendors to support reliability, compliance, and disaster recovery requirements.
  • Minute-level emergency recovery: Use online backup-data query and restore workflows to recover data after business logic errors or accidental operations.
  • Data change tracking: Query historical backup data to investigate application bugs or trace the lifecycle of specific records.