TechnicalCollectible prompt

Backup and restore plan with a tested restore

Know what's backed up and how much you could lose, then prove a restore works before you need it.

Claude CodeCodexCursor

Curated by Nvoka

Nvoka wordmark logo
Nvoka wordmark logoTechnical

Backup and restore plan with a tested restore

Act as a senior site reliability engineer. Create a backup and restore plan for my {{tech_stack}} app, which stores {{data_to_store}}. Before suggesting anything, find out what backups exist today by checking the hosting and database settings, or tell me exactly where to look. 1. Inventory what we'd lose: the database, uploaded files, environment variables and secrets, DNS records, auth settings, scheduled jobs, email templates and the code. Database backups often don't include uploaded files. 2. Agree targets with me: how much data we could afford to lose (for example 1 hour) and how long we could be down (for example 4 hours). These decide everything else. 3. Backups: - Point-in-time recovery for the database if our plan supports it, otherwise daily snapshots - A nightly off-platform copy in separate storage under a different account, encrypted, kept 30 days, with monthly copies kept a year - Uploaded files copied or versioned the same way - Secrets and config stored in a password manager or vault, not a plain file 4. Access: the app's own keys can't delete backups, and only named people can restore. 5. Restore test, actually run: restore last night's backup into a fresh project, time it, compare row counts and a sample of files, and confirm the app works against it. Repeat every quarter. 6. A runbook: step-by-step restores for a full outage, a single deleted table, and one user's data, with who does what. 7. Monitoring: an alert when a backup job fails or runs late. Never test a restore over production data. Return the plan as a short document with targets, schedule, storage, the runbook and the restore test results, plus anything that costs money so I can decide.
Technicalnvoka.com/library/nvoka-backup-and-restore-plan-with-a-tested-restoreScan to open
Technical

Backup and restore plan with a tested restore

Know what's backed up and how much you could lose, then prove a restore works before you need it.

Nvoka logo

Curated by Nvoka

Claude CodeCodexCursorWindsurf
Add to my library

Make it yours

Fill in the blanks and change any word. Only your copy changes, never the card.

Fill in the blanks

0 of 2 filled

Your prompt

Act as a senior site reliability engineer. Create a backup and restore plan for my {{tech_stack}} app, which stores {{data_to_store}}. Before suggesting anything, find out what backups exist today by checking the hosting and database settings, or tell me exactly where to look. 1. Inventory what we'd lose: the database, uploaded files, environment variables and secrets, DNS records, auth settings, scheduled jobs, email templates and the code. Database backups often don't include uploaded files. 2. Agree targets with me: how much data we could afford to lose (for example 1 hour) and how long we could be down (for example 4 hours). These decide everything else. 3. Backups: - Point-in-time recovery for the database if our plan supports it, otherwise daily snapshots - A nightly off-platform copy in separate storage under a different account, encrypted, kept 30 days, with monthly copies kept a year - Uploaded files copied or versioned the same way - Secrets and config stored in a password manager or vault, not a plain file 4. Access: the app's own keys can't delete backups, and only named people can restore. 5. Restore test, actually run: restore last night's backup into a fresh project, time it, compare row counts and a sample of files, and confirm the app works against it. Repeat every quarter. 6. A runbook: step-by-step restores for a full outage, a single deleted table, and one user's data, with who does what. 7. Monitoring: an alert when a backup job fails or runs late. Never test a restore over production data. Return the plan as a short document with targets, schedule, storage, the runbook and the restore test results, plus anything that costs money so I can decide.
See all