Transaction Log issues

[wfairbanks]

Other than letting the tranaction log file continuously grow in order for my db to update properly. Is there any other way I can prevent my log file from growing too large and preventing the update?

Thanks in advance

 

[magnificent1]

You should schedule a backup and set it to truncate on checkpoint. Otherwise the T-logs can grow ad grow disproportionately to the point of filling up your harddrive in no time.

 

[wfairbanks]

I did not see where you set it to truncate at checkpoint. Where do I do that????? Sorry I am new at this!