Steve,

How big is your database?  How much does it change in a day?  I've never
seen a log that big fill without operational problems preventing the
regular backup or the triggered backup to fail...

Steffan

Steven P Roder wrote:
>
> > I don't have any problems with the triggers because I force a DB backup
> > every day at the same time.  That clears the log, and so I don't have the
> > trigger
>
> I also had an admin schedule to "trigger" a daily DBbackup when I ran in
> Roll forward mode, but my 5GB log was filling during client backups
> anyway.  With a 5.3GB size limitation on the log, rollforward mode will
> not work for me.
>
> For rollforward to be viable here, ADSM development will first have to
> remove the size limitation on the recovery log.
>
> Steve (unVMix Systems Programmer/Dude) Roder
> (tkssteve AT ubvm.cc.buffalo DOT edu | tkssteve AT acsu.buffalo DOT edu | 
> (716)645-3564 ,
>    | http://ubvm.cc.buffalo.edu/~tkssteve)