However, if you've got a backup tape there's nothing from the current that will flip the bits on the tape itself.
There are good reasons to have the backup be off site (other physical calamities) - but the aurora isn't going to flip any bits on a backup. At worst, it will destroy the machinery from a surge from the grid and an extremely powerful one may destroy the machinery from arcing in the device itself (this would be extremely powerful)... but the media itself is fine.
I suspect you’re trying to be sarcastic and/or facetious, but:
Both ideally sure. The more backups and more locations the better. Diminishing returns pretty quickly but why not if the data is important.
Electromagnetic energy from the sun only has a chance of damaging equipment and only some of the bits of that equipment will be affected. You could have two servers in the same datacenter where one gets hit and the other does not. Or even two drives in the same chassis. And even then, it might not be all the data on that drive.
Of course no security is absolute (learned that early from my uncle that owned a convenience store at a lake: He spent extra on doors, locks, windows, etc and someone drove a truck through the brick wall to rob the place). Same here: if a solar event happens that would wipe out all of your onsite and offsite servers “on the surface” then there is a much bigger problem.
Underground or at the other side of the planet or both?