View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 07:49 PM
Chirath Fernando
 
Posts: n/a
Default SQL 2000 backup on DLT tape

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
Reply With Quote