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:[EMAIL PROTECTED]
Skickat: må 2003-03-03 08:19
Till: [EMAIL PROTECTED]
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.
