transaction log size

It is “normal” for LDF filesize to be about 120% of the MDF filesize – less than that there is no point shrinking the Log File as it will most likely grow back up to 120%

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.