• 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.