Home Forums SQL Server 2008 SQL Server 2008 Administration Removing log information from log file by using DBCC SHRINK FILE RE: Removing log information from log file by using DBCC SHRINK FILE

  • August 14, 2013 at 8:41 am

    #1641435

    EmptyFile is only valid when shrinking a data file. It's completely ignored when specified on a log file. Nothing can ever move log records around within a log file.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass