The common T-SQL script to shrink/truncate log file is using the script below

But, if the script runs on SQL Server 2008 instance, it will fail. You still have the same log file size, nothing change (shrink) . In other word you cannot shrink the log file.

To solve the issue here’s a work around:

Microsoft SQL Server 2008 has a default setting ‘FULL‘ for Recovery Model, so that means that we cannot just shrink Log File to minimum size.
Change the recovery model to ‘SIMPLE‘ and Shrink the Log File using:

If ‘FULL‘ Recovery Mode still needed, cause is crucial for transaction DB, you can use ALTER sql command to  change and recover Recovery Mode to its original state.


2 Comments Shrink / Truncate Log File On SQL Server 2008

  1. Marla
    Firefox 22.0 Firefox 22.0 Ubuntu x64 Ubuntu x64
    Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:22.0) Gecko/20100101 Firefox/22.0

    I do not even know how I stopped up right here, however I believed this publish was once
    great. I do not know who you’re however definitely you’re going to a famous
    blogger for those who are not already. Cheers!


Leave A Comment

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.