Conference decwet::windows-nt

5999.0. "SQL6.5 cannot restore from tapes written on TZ88" by CSC32::J_GONZALEZ (Tangled Up In Blues?) Mon May 12 1997 15:04

Hello, 

A Customer has TZ88 tape drives on Alpha system NT4.0 SP2, NT backup has no
problem with writing and reading tapes, but when he uses SQL 6.5 to write
and then read tapes, it fails.  Here is the the error information from Event 
Viewer;



MSSQLServer     Information     Kernel  17055   N/A     BPSDB10 Mesg 18225 :
                        Tape bench SS0007 mounted on tape drive \\.\TAPE0
MSSQLServer     Error           Kernel  17055   N/A     BPSDB10 Mesg 18233 :
                        tbsreadhdr: Tape rejected
MSSQLServer     Error           Kernel  17055   N/A     BPSDB10 Mesg 18250 :
                        tprhdrs: HDR1 label not found
MSSQLServer     Warning         Kernel  17055   N/A     BPSDB10 Mesg 18227 :
                        Unnamed tape tapedump0 mounted on tape drive \\.\TAPE0
MSSQLServer     Error           Kernel  17055   N/A     BPSDB10 Mesg 18246 :
                        tprvol: VOL1 label not found
MSSQLServer     Error           Kernel  17055   N/A     BPSDB10 Mesg 18210 :
                        read_db_hdr: Read failure on backup device 'nul',
                        returned operating system error (null)
NTBackup        Information     None    8009    N/A     BPSDB10 End Verify to
                         'D: Data One'
NTBackup        Information     None    8008    N/A     BPSDB10 Begin Verify
                         to 'D: Data One'
NTBackup        Information     None    8001    N/A     BPSDB10 End Backup of
       'D: Data One'     Verify:  On         Mode:  Replace       Type:  Normal
NTBackup        Information     None    8000    N/A     BPSDB10 Begin Backup
  of 'D: Data One'     Verify:  On         Mode:  Replace         Type:  Normal


Any help appreciated.

Thanks,

John Gonzalez
CSC 
   

    
    As I recall there is a technet article regarding tz87/88 and backups
    with Sql.