Printed 2017/08/17 06:03AM

SQL Server – Transaction Log File is Full; How to Shrink the Transaction Log

By VS Raavi, 2012/10/12

Here is a typical scenario every SQL Server DBA faces:  Transaction Log grows unexpectedly or becomes full!! So, do I need to increase the Log size? Fortunately we have a better solution – SHRINK the log file! Typically log truncation frees space in the log file for reuse by the Transaction Log thus releasing space and making it not […]
Copyright © 2002-2017 Redgate. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.