I've been asked to setup a backup job onto tape for our sql database. I'm unfamiliar with tape as I've always backed up to an offsite disk but need to backup to tape as well as part of our business continuity plan. I can backup to disk fine but when I use the wizard to familiarise myself with backing up to tape I get the error message: -
Write on tape drive (\\.\Tape0) failed error 19. These are new tapes so I presume I need to set the radio button to:
Backup to new media set, and erase all existing backup sets.
Hope you can help.