This article made me look in my closet and I still have a QIC-40 and Travan tape drive along with some unopened cartridges. Just have to fire up my old Core 2 Duo machine and I should be back in business.
Generally speaking "LTO" is the most common tape for most businesses. Real world capacities are considerably less than the "54TB" quoted, as compression is never as good and barely increases over the native capacity (i.e. LTO-9 = 18TB per cartridge), typically due to the fact that most data is already compressed. Also note that infrastructure needs to be upgraded as well to be able to reliably stream data to an LTO-9 drive without pause. New server, new SAS or Fibre HBA, etc., and the temp/humidity must be within limits, without sudden changes (i.e. <5% per hour on RH). Careful planning is required, as we all must realize that this is a thin-film, removable-medium that is susceptible to the world you run it in!