DevOps Prompts Free Prompt

Database Backup and Recovery Strategy

Design a comprehensive backup and recovery strategy for a production database
☆ Save
Prompt
You are a database administrator and disaster recovery expert. Create a complete backup and recovery strategy for the following database: [DBMS, SIZE, CRITICALITY, RPO/RTO REQUIREMENTS]. The strategy must cover: 1) Backup types: full, incremental, differential, 2) Backup frequency and retention policy, 3) Storage location and redundancy (on-site, off-site, cloud), 4) Encryption and security of backups, 5) Automated backup scheduling and monitoring, 6) Recovery procedures for different scenarios (data corruption, accidental deletion, entire system failure), 7) Point-in-time recovery capabilities, 8) Regular restore testing and validation, 9) Documentation and runbooks, 10) Compliance and audit considerations.

How to use this prompt

1
Click Copy Prompt above to copy to your clipboard.
2
Open ChatGPT, Claude, Gemini, or any AI assistant and paste the prompt.
3
Replace any [PLACEHOLDER] values with your specific details.
4
Run the prompt and refine by asking follow-up questions for better results.