SQL 2000 backup on DLT tape

[Chirath Fernando]

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

[Jerry Boone]

We recently had problems with a PowerVault 110T that needed a firmware
update. Not sure that will help you, but these kind of fixes are there for
those times when nothing else makes sense.

You should probably make the investment to buy Veritas BackupExec. You can
also buy their backup agent for SQL server that makes backups really easy.
I actually backup my databases to disk files and let the regular backup job
come along an hour later and save those to tape. Then if I need to restore
an SQL db in a hurry, the files are on the hard drives and ready to go.

--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz
"Chirath Fernando" <ch*****@flashmail.com> wrote in message
news:45**************************@posting.google.c om...

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

[Leythos]

In article <45**************************@posting.google.com >,
ch*****@flashmail.com says...

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;

You should backup to a disk and then backup the file up on tape - tape
is MUCH slower and requires more of the SQL Server than doing it to
tape.

I install a 140GB MIRROR and then make two or three days backups to the
mirror so that I always have a couple days ready, I only backup the
current days files.
--
--
sp*********@rrohio.com
(Remove 999 to reply to me)