Prompt lesson · 20 prompts
Backup and Recovery Procedures prompts for Database Administrators
20 ready-to-use prompts from our AI for Database Administrators course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Automate Database Backup Scripts and Integration
Use this when you need to script backup jobs, schedule automated backups, and integrate backup software with existing systems.
Role You are a database administrator and automation expert. Your goal is to help script backup jobs, schedule them reliably, and integrate backup software with existing systems, following best practices for security and efficiency.
Context you provide
- {{database_type}} – the type of database (e.g., PostgreSQL, MySQL, MongoDB)
- {{operating_system}} – the OS where the database runs (e.g., Linux, Windows)
- {{backup_tool}} – preferred backup tool or software (e.g., pg_dump, mysqldump, Veeam)
- {{current_setup}} – a brief description of the current backup infrastructure (optional)
- {{integration_target}} – the system to integrate with (e.g., cloud storage, tape library, NAS)
- {{schedule}} – desired backup frequency (e.g., daily incremental, weekly full)
Instructions
- Ask for missing context before proceeding.
- Provide a sample script for automating backup jobs for the given database type and OS, using the specified backup tool.
- List best practices for scheduling automated backups to ensure they run smoothly (e.g., error handling, logging, notifications).
- Guide the user on integrating the backup software with the integration target, including steps for connectivity and authentication.
- Include comments in the script to explain key parts.
Output format A short guide with:
- Sample script (with placeholder variables for paths, credentials)
- Scheduling best practices (bullets)
- Integration steps (numbered)
Use technical but clear language. 300–400 words.
Guardrails
- Do not include actual credentials; use placeholders.
- Flag any assumptions about the environment (e.g., permissions, installed tools).
- Stay within database backup automation; do not advise on unrelated infrastructure.
Example {{database_type: "PostgreSQL 15"}}, {{operating_system: "Ubuntu 22.04"}}, {{backup_tool: "pg_dump"}}, {{integration_target: "AWS S3"}}, {{schedule: "daily full backup at 2 AM"}}
Open this prompt Coding · Intermediate
Backup and Recovery Audit Checklist
Use this when you need to audit backup and recovery procedures for compliance and vulnerability identification.
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"
Open this prompt Analysis · Intermediate
Backup Encryption Implementation
Use this when you need to implement encryption techniques for database backups to protect sensitive data.
Open this prompt Planning · Advanced
Backup Integrity Verification
Use this when you need to verify the integrity and completeness of database backups to ensure data recoverability.
Open this prompt Analysis · Intermediate
Backup Job Monitoring Setup
Use this when you need to set up monitoring for backup jobs, including alerts for failures and best practices.
Open this prompt Automation · Intermediate
Backup Monitoring and Alerting Setup
Use this when you need to design a backup monitoring system with alerts and key performance indicators.
Open this prompt Planning · Intermediate
Backup Strategy Optimization
Use this when you want to optimise your database backup process by comparing incremental, differential, and parallel backup techniques.
Open this prompt Analysis · Beginner
Backup Verification Guide
Use this when you need to verify the completeness and integrity of your database backups.
Open this prompt Planning · Intermediate
Configure Database Backup Settings
Use this when you need to set up or optimize database backup configurations, including location, compression, encryption, and retention.
Open this prompt Planning · Intermediate
Create Disaster Recovery Procedures
Use this when you need to design or document disaster recovery procedures for databases or data centers.
Open this prompt Planning · Advanced
Database Backup Compression Guide
Use this when you need a detailed guide on implementing backup compression for your databases to optimize storage and recovery efficiency.
Open this prompt Planning · Intermediate
Database Disaster Recovery Planning
Use this when you need to create or update a disaster recovery plan for databases.
Open this prompt Planning · Intermediate
Database Recovery Planning
Use this when you need to create a recovery plan for critical databases, including prioritization and RTO definition.
Open this prompt Planning · Advanced
Define Backup Retention Policies
Use this when you need to create database backup retention policies that balance compliance, recovery needs, and storage costs.
Open this prompt Planning · Beginner
Design Database Recovery Tests
Use this when you need to create a framework for testing database backup and recovery procedures, including scenarios and best practices.
Open this prompt Planning · Intermediate
Implement Incremental Backups
Use this when you need to plan and implement incremental backups for a specific database system.
Open this prompt Planning · Intermediate
Offsite Backup Storage Strategy
Use this when you need to develop a secure, cost-effective offsite backup storage plan to ensure data redundancy.
Open this prompt Planning · Intermediate
Point-in-Time Database Recovery
Use this when you need to restore a database to a specific point in time and understand the necessary steps and tools.
Open this prompt Learning · Advanced
Point-in-Time Recovery Guide
Use this when you need to restore a database to a specific past moment and need step-by-step guidance.
Open this prompt Planning · Intermediate
Schedule Database Backups
Use this when you need to create or manage a backup schedule for databases to ensure regular, reliable backups.
Open this prompt Planning · Beginner