submitted 4 months ago* (last edited 4 months ago) by to c/selfhosted@lemmy.world
 

Somehow I had a database corruption and I did not know how to restore from backup. It was a bad experience until I saw that it worked. Make regular and check your backups.

all 25 comments

sorted by: hot top controversial new old
[–] 59 points 4 months ago (5 children)

An untested backup is not a backup, it's a wish.

  • source
  • hideshow 5 child comments
  • [–] 29 points 4 months ago (4 children)

    Also known as Schrödinger's Backup.

  • source
  • parent
  • hideshow 4 child comments
  • [–] 13 points 4 months ago (3 children)

    Schrödinger did not have a backup cat.

  • source
  • parent
  • hideshow 3 child comments
  • [–] 20 points 4 months ago (2 children)

    How do you guys test your backups?

    I have restored my proxmox setup from backup and it worked, but that is not something I do on regular basis.

    I have from time to time done spot checks that certain files are working.

    Most of the time I rely on the verification done by proxmox backup server..

  • source
  • hideshow 2 child comments
  • [–] 3 points 4 months ago*

    PBS verification is only a checksum of file integrity. If somehow the backup was zero-length, or was otherwise corrupt, the verification would succeed but the backup would be useless. How often you do file or full restores is up to you, but required for actual verification.

  • source
  • parent
  • [–] 10 points 4 months ago

    That's a gimmie. I test server image backups in a VM. So far, I've never had to resort of a backup, but I don't want to find out that my image is worthless if I ever had the need.

  • source
  • [–] 6 points 4 months ago (1 child)

    Narrator: The fire detector in fact did not work.

    There's more than one kind of backup in life, check them all.

  • source
  • hideshow 1 child comment
  • [–] 4 points 4 months ago (2 children)

    3, 2, 1.... Test the backup!

    ... Is that the rule, right?

  • source
  • hideshow 2 child comments
  • [–] 4 points 4 months ago (1 child)

    Two backups is one and one is none.

  • source
  • hideshow 1 child comment
  • [–] 3 points 4 months ago

    I run Borg backup, and I did a successful live test yesterday. Deleted the wrong file and hade to restore it.

  • source
  • [–] 3 points 4 months ago (2 children)

    this drove me nuts at workplaces. we have to test the backups after backup. so many did not want to waste the resources. if it worked fine once it will always work fine to them.

  • source
  • hideshow 2 child comments
  • [–] 1 point 4 months ago* (last edited 4 months ago) (2 children)

    Somebody tell that to tindie.com !

  • source
  • hideshow 2 child comments
  • [–] 0 points 4 months ago

    rule of thumb. any backup you don't regularly test isn't a backup.

  • source