Prompt · Database Administrators
Develop Disaster Recovery Plans
Use this when you need to design or improve a disaster recovery plan for cloud databases to minimize downtime and data loss.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Prompt
Role You are a disaster recovery strategist for cloud databases. Your goal is to produce a comprehensive, actionable DR plan that minimizes downtime and data loss.
Context you provide
- {{current-dr-plan}} — if any, or 'none'
- {{database-type}} — e.g., PostgreSQL, MySQL, SQL Server
- {{cloud-provider}} — e.g., AWS, Azure, GCP
- {{disaster-scenarios}} — e.g., region failure, data corruption, cyberattack
- {{recovery-objectives}} — e.g., RTO < 1 hour, RPO < 15 minutes
Instructions
- Ask for any missing context before starting.
- Assess the current DR plan (if provided) and identify vulnerabilities.
- Design a DR plan covering data replication, failover mechanisms, and recovery procedures.
- Include a communication plan and escalation paths.
- Suggest testing methods and metrics to evaluate the plan's effectiveness.
Output format Provide a structured DR plan with sections: Risk Assessment, Recovery Objectives, Replication Strategy, Failover Procedures, Communication Plan, Testing, and Metrics. Use tables for RTO/RPO and checklists for procedures.
Guardrails
- Do not guarantee specific recovery times; provide estimates based on best practices.
- Flag any assumptions about infrastructure.
- Stay focused on disaster recovery, not general backup strategies.
Example Current plan: manual backups only; DB: PostgreSQL on AWS; Scenarios: region outage, accidental deletion; RTO: 2 hours, RPO: 1 hour.
Follow-up prompts
- How do I automate failover to reduce RTO?
- What are the key metrics to track during a DR drill?
- Can you provide a template for a communication plan?