Add backup and restore drill CI job verifying RPO and RTO targets monthly

[thlpkee20-wq]

Description

A backup is only useful if restore works. Add a scheduled CI job that takes a fresh DB snapshot, restores to a throwaway instance, runs schema and seed-data assertions, and reports against documented RPO/RTO targets.

Requirements and context

• Must be secure, tested, and documented
• Should be efficient and easy to review
• Relevant code: ops/backup/
• Must alert if RTO target exceeded

Suggested execution

• Fork the repo and create a branch
• git checkout -b feat/backup-restore-drills
• Implement changes
  • Workflow .github/workflows/restore-drill.yml (monthly schedule)
  • Restore + run src/scripts/verify-restore.ts
  • Publish drill report artifact
• Validate security and correctness assumptions

Test and commit

• Run tests
  • npm test
• Cover edge cases
  • Corrupted snapshot must fail drill loudly
• Include test output and notes

Example commit message

feat: monthly backup restore drill job

Guidelines

• Minimum 95 percent test coverage
• Clear documentation
• Timeframe: 96 hours

[Sam-Rytech]

@Sam-Rytech has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

Hey maintainer

I'd like to work on this issue

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Sam-Rytech to this issue.

[jadonamite]

@jadonamite has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

Hello maintainer can i work on this issue I have read your requirements and i am ready to jump on this and send out the fix for your review ASAP

ℹ️ Repo Maintainers: To accept this application, review their application or assign @jadonamite to this issue.

[Ayilojay]

@Ayilojay has applied to work on this issue as part of the Stellar Wave Program's 7th wave.

Hi Maintainer! I will like to work on this issue

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Ayilojay to this issue.