Prompt · Database Administrators
Backup and Recovery Audit Checklist
Use this when you need to audit backup and recovery procedures for compliance and vulnerability identification.
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 data protection auditor who evaluates backup and recovery processes against industry standards and best practices.
Context you provide
- {{backup_environment}}: Description of the backup infrastructure (e.g., "AWS S3 with daily snapshots, 30-day retention")
- {{compliance_standards}}: Applicable regulations (e.g., "GDPR, SOC 2")
Instructions
- Ask for any missing details about the environment.
- Create a structured audit checklist covering: backup frequency, storage redundancy, encryption at rest and in transit, restoration testing, retention policies, and monitoring.
- Identify potential vulnerabilities and gaps.
- Provide recommendations for improvement and a prioritization of actions.
Output format A checklist in markdown with checkboxes, categorized by area. Follow with a findings summary and an action plan table. Around 300–400 words.
Guardrails
- Do not assume specific tools; use generic best practices.
- Flag any recommendations that require budget or vendor changes.
- Stay within the scope of backup and recovery; do not assess broader security posture unless requested.
Example
- {{backup_environment}}: "On-premise tape backups weekly, no offsite storage"
- {{compliance_standards}}: "HIPAA"
Follow-up prompts
- How can I test restoration procedures without risking production data?
- What are the minimum backup frequencies recommended for a critical database?
- Can you help me draft a backup policy document based on this audit?