Went to do a test restore of one of my databases and I noticed the dump files over the last few months were all 0kb. Glad I caught it this way and not because I needed to restore. Put it on your calendar, schedule a test restore of your critical stuff a couple times a year. I know y’all are busy but it is worth the time and effort. A backup you can’t actually restore isn’t a backup at all.

  • ComradeMiao@lemmy.dbzer0.com
    link
    fedilink
    English
    arrow-up
    1
    arrow-down
    1
    ·
    8 days ago

    Thanks for explaining this! Very helpful and easy to understand. Do you have preferred programs for the two actions? I currently just rsync my servers.

    • capital@lemmy.world
      link
      fedilink
      arrow-up
      2
      ·
      8 days ago

      I use restic to back up files to Wasabi.

      It’s all scripted but the steps are:

      1. Back up
      2. Prune based on rules
      3. Perform a repository consistency check and do further checks (takes longer) on 1% of the repo
      4. Choose 1 random file from the current backup set and get the hash of the current file
      5. Restore that file to a temporary location and hash it.
      6. Compare hashes
      7. Send push alert to me with success/failure and a summary