Skip to Content

Know The Difference Between Truncating And Shrinking Database Log File

Know The Difference Between Truncating And Shrinking Database Log File

Submitted by • February 10, 2020 www.systoolsgroup.com

So let this illusion be cleared in this blog, that both truncate and shrink are not the same, but different. Now, you might be thinking that what is different in both? Well! The truncate process modifies VLF or Virtual logfile from active to the inactive state. Whereas, the Shrinking process bring down the physical log size to a smaller or manageable size.

Voted by:
Voted by ellestephen1458

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>