Documentation›Database Service›Backup & Recovery

Backup & Recovery

Comprehensive backup strategies and disaster recovery solutions

99.97%

Backup Success Rate

4.2 min

Average Backup Time

< 15 min

Recovery Time Objective

24/7

Point-in-Time Coverage

Backup System Overview

VPN Enterprise provides automated, secure, and reliable backup solutions with multiple recovery options. All backups are encrypted, compressed, and stored across multiple availability zones for maximum durability.

Automated Scheduling

Continuous, hourly, daily, or custom intervals

Point-in-Time Recovery

Restore to any second within retention period

Cross-Region Replication

Automatic backup replication to multiple regions

Backup Types

Automated BackupsRecommended

Scheduled backups with configurable frequency and retention

Configuration

Frequency:Continuous, Hourly, Daily, Weekly

Retention:Up to 35 days

Features

Point-in-time recovery

Compression

Encryption

Cross-region replication

Manual Backups

On-demand backups triggered manually or via API

Configuration

Frequency:On-demand

Retention:Custom (up to 1 year)

Features

Named snapshots

Custom metadata

Export capability

Long-term retention

Continuous Backup

Real-time backup with sub-second recovery points

Configuration

Frequency:Real-time

Retention:7-35 days

Features

Zero data loss

Instant recovery

Transaction log backup

Hot standby

Recovery Scenarios

Point-in-Time Recovery

Restore database to any specific moment in time

Scenario Details

Use Case: Recover from accidental data modification or deletion

Timeframe: Any point within retention period

Expected Downtime: 5-15 minutes

Recovery Commands

db-cli restore my-database --point-in-time '2024-01-15 14:30:00'

db-cli restore my-database --pit-relative '2h ago'

Full Database Restore

Complete restoration from backup snapshot

Scenario Details

Use Case: Recover from complete database corruption or loss

Timeframe: From any available backup

Expected Downtime: 10-30 minutes

Recovery Commands

db-cli restore my-database --backup-id backup_20240115_143000

db-cli restore my-database --latest-backup

Cross-Region Restore

Restore database in a different geographic region

Scenario Details

Use Case: Disaster recovery or geographic relocation

Timeframe: From replicated backups

Expected Downtime: 15-45 minutes

Recovery Commands

db-cli restore my-database --backup-id backup_20240115_143000 --region eu-west-1

db-cli restore my-database --cross-region --target-region ap-southeast-1

Clone from Backup

Create new database instance from existing backup

Scenario Details

Use Case: Testing, staging, or development environments

Timeframe: From any backup

Expected Downtime: None (new instance)

Recovery Commands

db-cli clone my-database --backup-id backup_20240115_143000 --name my-database-test

db-cli clone my-database --name staging-db --latest

Backup Strategies by Environment

Development Environment

Basic backup for development and testing

Frequency:

Daily

Retention:

7 days

Cost:Low

Features

Automated backups

Local region

Basic encryption

Setup Command

db-cli backup-policy create \
  --database my-dev-db \
  --frequency daily \
  --retention 7d \
  --compression enabled

Production Standard

Comprehensive backup for production workloads

Frequency:

Hourly

Retention:

30 days

Cost:Medium

Features

Automated + manual

Cross-region replication

Point-in-time recovery

Setup Command

db-cli backup-policy create \
  --database my-prod-db \
  --frequency hourly \
  --retention 30d \
  --cross-region enabled \
  --pit-recovery enabled

Enterprise Mission-Critical

Maximum protection for critical business data

Frequency:

Continuous

Retention:

90 days

Cost:High

Features

Continuous backup

Multi-region

Zero data loss

Hot standby

Setup Command

db-cli backup-policy create \
  --database my-critical-db \
  --frequency continuous \
  --retention 90d \
  --multi-region enabled \
  --hot-standby enabled \
  --zero-data-loss true

Backup Management

Backup Configuration

Configure backup policies and schedules for your databases

# Create backup policy
db-cli backup-policy create \
  --database my-database \
  --frequency hourly \
  --retention 30d \
  --compression gzip \
  --encryption aes-256 \
  --cross-region enabled

# Update existing policy
db-cli backup-policy update my-database \
  --frequency daily \
  --retention 90d

# Enable point-in-time recovery
db-cli backup-policy enable-pitr my-database \
  --retention 7d

# Configure backup window
db-cli backup-policy window my-database \
  --start "02:00" \
  --duration "4h" \
  --timezone "UTC"

Best Practices

Test Your Backups Regularly

Critical

Perform regular recovery drills to ensure backups are working

Schedule monthly recovery tests to staging environments

Use Cross-Region Replication

High

Store backups in multiple geographic regions for disaster recovery

Enable cross-region replication for production databases

Implement Backup Monitoring

High

Set up alerts for backup failures and unusual patterns

Configure notifications for backup status changes

Document Recovery Procedures

Medium

Maintain clear documentation of recovery processes

Create runbooks with step-by-step recovery instructions

Validate Backup Integrity

High

Regularly check backup files for corruption or issues

Enable automatic integrity checks after each backup

Next Steps

With backup and recovery configured, learn about scaling your database infrastructure and optimizing performance.