Truncate log on checkpoint

[asgar5292]

Hello
I want to Truncate my Transcation log file , how to do it

[kalareddy]

Hello,

You can reduce or truncate the log files using any of the following ways.

A DBCC SHRINKDATABASE statement is executed.
A DBCC SHRINKFILE statement referencing a log file is executed.
An autoshrink operation occurs.

In SQL Server 2000, a DBCC SHRINKDATABASE or DBCC SHRINKFILE operation attempts to shrink the physical log file to the requested size immediately.

you can read more on this in Books online if you have SQL Server installed on your pc or try msdn.


http://msdn.microsoft.com/library/de...r_da2_7vaf.asp

Thanks,