“What kind of computer system backups will survive”
^^^^^^^
Anything burned to DVD will be fine.
Your computer’s hard drive, motherboard, processor, graphics card, networking, and external hard drive will be toast. So will your vehicle’s electronics, unless you have an early 1980s or earlier model.
It’s a good idea to regularly burn everything to DVD, and keep the copies in a bag you can bug out with. If the worst case happens, you’ll be able to restore your data someday when computers come back.
So backup tapes will not survive.