Home Forums SQL Server 2005 Administering Shrink Transaction Logs in SQL 2005 RE: Shrink Transaction Logs in SQL 2005

  • July 20, 2008 at 1:54 am

    #845384

    ramdas.narayanan (7/18/2008)

    Hi folks,

    What would be the fastest way to shrink the transaction logs in SQL 2005, would it be using DBCC SHRINKFILE after taking the full backup of the log.

    Thank you

    Think this method below would help you : 🙂

    BACKUP LOG name WITH TRUNCATE_ONLY

    USE db

    DBCC SHRINKFILE (name_Log, 1)