In article <45b4c7c1.0311162314.5a90c471@posting.google.com >,
chirath@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.


--
--
spamfree999@rrohio.com
(Remove 999 to reply to me)