Doesn't MS SQL 7 have a means to do a block-level incremental backup on a
database (not to be confused with transaction log dumps) ?   This would
allow you to limit the long backup to say once/week.

I don't know if this special 'incremental' dump works with the
Veritas agent though.

The other thing to keep in mind is that the Sun E220R has a 64-bit PCI bus
and a 32-bit PCI bus.   You want to make sure that you have split devices
across the busses to avoid overloading that 32 bit bus.   The 64 bit bus
only gives you 1 slot I believe, the other 3 and the internal SCSI host
are all on the 32 bit bus.

Jon

On Tue, 8 Jan 2002, Todd Suiter wrote:

> All,
> 
>       Thanks to those who responded...some clarification: msql==Micrsoft SQL 
> 7. I'm running the NBU DB Backup Agent on this host as well.  After looking
> around at the previous backup admin's notes, they had done this with this
> machine once before, setting Striping to an unnamed #, and using 6 drives. And
> it took something like 15 hours to back up. Assuming this is correct(I need
> to turn it on to verify), does anyone know how to speed it up? 15 hours is
> a heck of a long time for my backup system to be working on a single host...
> 
> TIA...t
> 
> On Mon, 7 Jan 2002, Todd Suiter wrote:
> 
> > Okay, need some advice.
> >
> > I've got 1.5TB worth of msql data to backup with NBU 3.4.x. Running a GigE
> > attached Sun 220R (solaris 7), and 2 atl p1000's fully loaded(8 drives) 
> > dlt's. How do I set this thing up to backup?
> >
> > _______________________________________________
> > Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
> > http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
> >
> 
> _______________________________________________
> Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
>