September 3, 2008 at 12:28 am
we have defined the recovery mode as simple for databse xxxx .but transaction log file not getting truncated like tempdb.
Thanks in Advance .
September 3, 2008 at 1:00 am
By truncated, you mean "shrinked"?
It's a misunderstandind that a transaction log will stay small; the size of the transaction log depends on your transaction. If you update a large table in one transaction, your logfile will become very big, regardless of your recovery mode. Keep in mind that transaction log is also used for rollback situations, all your DML activities are logged.
However, if you use simple recovery mode the used space in the transaction log will be released after a commit/rollback which means it can be overwritten, not truncated / shrinked.
It's not wise to shrink your transaction log if it's growing back tot a regular size (which makes the shrink useless). Shrinking and growing gives a big impact on your server and is asking for fragmentation. This is also for datafiles!
Wilfred
The best things in life are the simple things
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply