Thanks for the reply.
I was using the latest Veritas drivers, and latest Service pack. I've tried with hardware compression, software compression and no compression.
With any kind of compression I get about 120-140GB on the 200GB tape
with no compression I get 100G
If I use backup to disk with compression enabled the whole 260G backup is saved to a directory where the total size of the backup is 155G
I, uploaded the latest Sony driver, and have so far tried Hardware compression and no compression with the same results.
I have a few more tests to do including the diagnostics which will take me another week as I only get 4 hours testing time per day (which I have to do in my own time from 8pm till midnight) and it takes roughly 4 hours to get to the point where the backup ejects the tape.