http://www.sqlservercentral.com/blogs/sqlserverzestcom-sql-in-simple-style/2012/10/12/sql-server-transaction-log-file-is-full-how-to-shrink-the-transaction-log/

Printed 2014/07/25 10:44AM

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-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.