Thanks George.
I agreed with you for the first one not to shrink frequently.
I can set up the log back up hourly instead of every two hrs.
Now when you say " Set the log to the size it needs to be to handle your activity, set a sensible growth factor and leave it there. " I have currently set up 10%, unrestricted growth, what you suggest for Initial size and growth ideal settings?
We have MS CRM application running on this DB.
Thanks.