Hi All – The link http://support.microsoft.com/kb/62866/

suggests that you can set the transaction log never to truncate by setting "trunc. log on chkpnt" option to false. It also explains why it does not get truncated even if it is set to true.

But I tried by selecting option FALSE as well as TRUE but still Transaction file gets truncated.

EXEC sp_dboption 'DB_Name','trunc. log on chkpt', 'TRUE'

EXEC sp_dboption 'DB_Name','trunc. log on chkpt', 'FALSE'

Any idea??
 

Thanks,

Baddy