Home Forums SQL Server 2008 SQL Server 2008 - General Best way to truncate a log in simple mode ? RE: Best way to truncate a log in simple mode ?

  • August 30, 2012 at 3:40 am

    #1531769

    FOR 2008

    USE 2008db;

    GO

    DBCC SHRINKFILE (<logical_logfilename>,5);

    GO

    For sql 2008

    5- size you want to shrink to.

    <logical_logfilename> run sp_helpdb.