Backup your Transaction Log more often at least every 4 or 6 hours but make sure that the option Remove inactive entries is checked so that the log file size will be reduced. I would suggest you to include this process in your maintenance plan.
>Transaction log is very big as it is taking tens of giga bytes of space. How can I reduce the size?
>
>Thanks
>Bharat
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."