Kruton ( XXXX@XXXXX.COM ) writes:
Why would you truncate the transaction log in the first place?
If you run with full recovery and want to be table to restore to a point
in time, the you should backup your transaction log regularly.
If you don't care about the point-in-time restores but are content with
restoring from a full backup in case of a failure, you should set the
database in simple recovery.
Erland Sommarskog, SQL Server MVP, XXXX@XXXXX.COM
Books Online for SQL Server 2005 at
Books Online for SQL Server 2000 at