Geoffrey,
Switching to roll-forward mode can be done at any time. As Wanda said, it
kicks off a full database backup to allow it to zero the log at a known
point.
Once in roll-forward mode, database changes will accumlate in the recovery
log until the next DB backup so log consumption will go up greatly.
>From your statistics I see that your log is 2000 MB:
Log:
Available Space (MB): 2,000
Assigned Capacity (MB): 2,000
Maximum Extension (MB): 0
Maximum Reduction (MB): 1,996
Page Size (bytes): 4,096
Total Usable Pages: 511,488
Used Pages: 279
Pct Util: 0.1
Max. Pct Util: 89.3 <--- How??
I'm curious about one thing though. When in "normal" mode, log consumption
rarely should exceed about 1%. Yet your statistics show a max utilization
of 89.3%. How did you do that in NORMAL mode?
I operate in roll-forward mode all the time, and the max consumption on my
log is about 60%.
Thanks.
Tab Trepagnier
TSM Administrator
Laitram Corporation
