Complete AI Training

Prompt · Database Administrators

Backup and Recovery Audit Checklist

Use this when you need to audit backup and recovery procedures for compliance and vulnerability identification.

All 20 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. 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

  1. Ask for any missing details about the environment.
  2. Create a structured audit checklist covering: backup frequency, storage redundancy, encryption at rest and in transit, restoration testing, retention policies, and monitoring.
  3. Identify potential vulnerabilities and gaps.
  4. 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?