SV: dbbackup trigger

Hi Henrik!
 
Yes, an incremental dbbackup will lower your log pct. util., however if your 
database backup is running when there is a lot of activity the log could build 
up very fast again.
 
If you have calculated the log-size correctly, i would suggest to raise the 
logfullpct to about 75 pct. to avoid the high activity hours and perhaps 
increase the log size.
Also, have a look at the numincremental value, perhaps that has to be lowered.
 

        -----Ursprungligt meddelande----- 
        Från: Henrik Wahlstedt [mailto:shwl AT STATOIL DOT COM] 
        Skickat: må 2003-03-03 08:19 
        Till: ADSM-L AT VM.MARIST DOT EDU 
        Kopia: 
        Ämne: dbbackup trigger
        
        

        Good morning!
        
        First of all things.. I use 4.1.3.0 on w2k.
        Second, I have my log (3GB) in  roll forward mode and use a dbbackup
        trigger which kicks off at log full percentage=40.
        I belived that an incremental dbbackup would lower my logs pct. 
utilized,
        but I might be wrong? After an incremantal dbbackup I get an anr4556.
        
        How high must I update my log full percentage to reset log 
pct.utilization?
        
        
        
        
        ANR4556W Attention: the database backup operation did not
         free sufficient recovery log space to lower utilization
         below the database backup trigger. The recovery log size
         may need to be increased.
        
        Help 4556,
        ....
        User Response: If a database backup operation does not free up enough
        recovery log space to reset utilization below the database backup 
trigger,
        the recovery log needs to be extended or the database backup trigger
        updated
        to a higher log full percentage.
        
        
        
        -------------------------------------------------------------------
        The information contained in this message may be CONFIDENTIAL and is
        intended for the addressee only. Any unauthorised use, dissemination of 
the
        information or copying of this message is prohibited. If you are not the
        addressee, please notify the sender immediately by return e-mail and 
delete
        this message.
        Thank you.