Indeed error 6 indicates a drive or tape issue. As you have tried multiple tapes then the drive probably needs repair. A new LTO-7 tape drive is a good idea as you can restore existing tapes and also create new archives. You can use LTO-7 tapes which are faster and have a larger capacity.
Ideally you should have at least two copies, each stored in a different stable environment, if this is the case then there is no immediate need to migrate the tapes.
If you just have one copy then you can start to restore your LTO-6 tapes and then create new archives on LTO-7 storing up to four LTO-6 tapes on each new tape. Regarding newer tape generations it depends on the amount of data that you will be creating. At the moment I would stick to the LTO-7 drive and then reassess the situation in a year or two. LTO-10 stores up to 30TB but is currently expensive, but in the future when the price comes down for drives and media then your 300 tapes would fit on about 20 LTO-10 tapes.
If you have indexes of each tape in the PreRoll Post database then you should be able to export these as CSV files. Then when needing a file you can search the CSV to give you the tape name.
It’s then easy to index that tape and restore selected files, folders or the entire tape using an app that supports LTFS. Our YoYotta software with LTO drive support allows you to do this and you can test the workflow using our demo version.
You can then start to index the other tapes using YoYotta. Note that YoYotta does not import PreRoll Post CSV files. Whilst you have 300 tapes it only takes a few minutes to index each tape and you will then have an accurate snapshot. YoYotta can also be used to verify existing LTO-6 tapes.
I hope this helps, please get in touch if you need more workflow advice.
Martin Greenwood
CTO
YoYotta
support@yoyotta.com