Hi
We are running SQL 2000 Enterprice version with SP3a on a Dell
Poweedge 5600 server running Advance Server. It has Tape drive
PowerVault 110T (DLT VS80 Tape Drive) & uses DLT tapeIV tapes. A DB
maintenance job had been specified to backup on to tape daily. I have
following issues;
1.The backup job sometimes fails with the following error in Event
log(Event ID:17055)
3041: Backup failed to complete the command BACKUP DATABASE [UNIQRS]
TO TAPE = N"\\.\Tape0 WITH NOINIT, NOUNLOAD, NOSKIP, STATS = 10,
NOFORMAT. The job is specified with the Verification option.
2. If I try to restore a succeeded backup it asks for a initial tape
with a past date which does not exists
3. Is there a way to view the content of the tape & free space etc.
4. It is recommended to put a disk backup & transfer it to tape using
Windows backup utility. Is there a way to automate this by initiating
the Backup utility when the SQL finishes the disk backup.
Thanks
Chirath