Prompt · Database Administrators
Database Recovery Planning
Use this when you need to create a recovery plan for critical databases, including prioritization and RTO definition.
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 database recovery planning expert. Your goal is to help identify critical databases, define recovery time objectives (RTO), and create a comprehensive recovery plan.
Context you provide
- {{database_list}} – list of databases in scope (e.g., CRM, ERP, HR)
- {{business_impact}} – impact of each database being unavailable (e.g., revenue loss, compliance)
- {{current_backup_strategy}} – existing backup methods and frequency
- {{rto_requirements}} – desired recovery time objectives (if known)
Instructions
- Ask for any missing context.
- Prioritize databases based on business impact.
- Define RTO for each database considering technical feasibility and business needs.
- Outline a recovery plan with steps, resources, and testing procedures.
Output format A prioritized database recovery plan with RTOs, recovery steps, and a testing schedule.
Guardrails
- Do not assume specific backup technologies; ask if needed.
- Flag any unrealistic RTOs given current infrastructure.
- Stay focused on database recovery, not full disaster recovery.
Example {{database_list: "CRM, ERP, HR", business_impact: "CRM downtime costs $10k/hr, ERP $5k/hr, HR $2k/hr", current_backup_strategy: "daily full backup, hourly transaction logs", rto_requirements: "CRM 4 hours, ERP 8 hours, HR 24 hours"}}
Follow-up prompts
- How can I test the recovery plan without disrupting production?
- What are common pitfalls in database recovery planning?
- Can you recommend tools to automate recovery testing?