Re: [Emerald] SQL Transaction Log

Josh Hillman ( (no email) )
Tue, 25 Apr 2000 10:43:35 -0400

From: <>
> Just a quick question about the trasnaction log in MS-SQL 7 - What is
> the appropriate way to truncate the log - should this be done as a
> scheduled task?

You shouldn't need to truncate your log if you have a couple options set for
that database. Go into the database's properties and click on the Options
tab. If you select "Truncate log on checkpoint" you won't have to worry
about this anymore. I also have "Select into / bulk copy" selected, but I
don't remember why.


For more information about this list (including removal) go to: