• SQLALX (1/28/2013)


    How to shrink transaction log file: http://bit.ly/XaDOQr

    Ok, I followed all the steps in that article and it did indeed shrink the logfile down to 1mb.

    So now I have:

      mdf = 973mb

      ldf = 1mb

    Which produces a backup file of 945mb. So does this sound about right, there is no compression

    enabled on the server.