Printed 2016/12/08 07:53AM

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-2016 Redgate. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.