Backup Disaster Recovery

aj-geddes/useful-ai-prompts/skills/backup-disaster-recovery

by aj-geddes3f5182cfd739No license355 starsListed Oct 8, 2026Updated Oct 8, 2026Repository updated 7 months ago

Implement backup strategies, disaster recovery plans, and data restoration procedures for protecting critical infrastructure and data.

AI-generated overview

Designs backup strategies, disaster recovery plans, and data restoration procedures for critical infrastructure.

What it does
This skill guides the design and implementation of backup and disaster recovery strategies, covering database backup configuration, restore scripts, cross-region failover, and disaster recovery plan templates. It produces configuration examples, recovery procedures, and planning documents, and ships a schema validation script plus a migration SQL template.
When to use it
Use it when planning data protection, business continuity, or disaster recovery, including point-in-time recovery, cross-region failover, data migration, and compliance or audit requirements.
Requirements
Runs shell scripts (scripts/validate-schema.sh) and includes reference documents and a SQL migration template. Database backup examples reference PostgreSQL connection settings and credentials such as POSTGRES_HOST, POSTGRES_USER, and POSTGRES_PASSWORD.

Backup and Disaster Recovery

Table of Contents

Overview

Design and implement comprehensive backup and disaster recovery strategies to ensure data protection, business continuity, and rapid recovery from infrastructure failures.

When to Use

  • Data protection and compliance
  • Business continuity planning
  • Disaster recovery planning
  • Point-in-time recovery
  • Cross-region failover
  • Data migration
  • Compliance and audit requirements
  • Recovery time objective (RTO) optimization

Quick Start

Minimal working example:

yaml
# postgres-backup-cronjob.yamlapiVersion: v1kind: ConfigMapmetadata:  name: backup-script  namespace: databasesdata:  backup.sh: |    #!/bin/bash    set -euo pipefail
    BACKUP_DIR="/backups/postgresql"    RETENTION_DAYS=30    DB_HOST="${POSTGRES_HOST}"    DB_PORT="${POSTGRES_PORT:-5432}"    DB_USER="${POSTGRES_USER}"    DB_PASSWORD="${POSTGRES_PASSWORD}"
    export PGPASSWORD="$DB_PASSWORD"
    # Create backup directory    mkdir -p "$BACKUP_DIR"
    # Full backup    BACKUP_FILE="$BACKUP_DIR/full-$(date +%Y%m%d-%H%M%S).sql"// ... (see reference guides for full implementation)

Reference Guides

Detailed implementations in the references/ directory:

GuideContents
Database Backup Configuration [blocked]Database Backup Configuration
Disaster Recovery Plan Template [blocked]Disaster Recovery Plan Template
Backup and Restore Script [blocked]Backup and Restore Script
Cross-Region Failover [blocked]Cross-Region Failover

Best Practices

✅ DO

  • Perform regular backup testing
  • Use multiple backup locations
  • Implement automated backups
  • Document recovery procedures
  • Test failover procedures regularly
  • Monitor backup completion
  • Use immutable backups
  • Encrypt backups at rest and in transit

❌ DON'T

  • Rely on a single backup location
  • Ignore backup failures
  • Store backups with production data
  • Skip testing recovery procedures
  • Over-compress backups beyond recovery speed needs
  • Forget to verify backup integrity
  • Store encryption keys with backups
  • Assume backups are automatically working

Source and attribution

Source:aj-geddes/useful-ai-promptsinskills/backup-disaster-recoveryat commit3f5182c

License: No license

Content belongs to its original authors. SourceWeft indexes it from a public repository.

Report or request removal

Backup Disaster Recovery · skills/backup-disaster-recovery Agent Skill | SourceWeft