The never shrinking transaction log

I keep forgetting how to force the transaction log in SQL Server to shrink, so I’m posting here primarily so I know where to find the how to :). Often the log does not shrink when you try to shrink from SQL Managent Studio. The solution, before you shrink the database do:


BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY


Thanks to Pinal Dave for this one (see his post SQL SERVER – Shrinking Truncate Log File – Log Full)

Leave a Reply

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