467,885 Members | 1,283 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,885 developers. It's quick & easy.

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
Jul 20 '05 #1
  • viewed: 5756
Share:
2 Replies
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

Jul 20 '05 #2
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)
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Mirko Slavko | last post: by
6 posts views Thread by A.Y. Xu | last post: by
9 posts views Thread by Stanley Sinclair | last post: by
5 posts views Thread by David | last post: by
reply views Thread by pjbr34 | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.