• The EmptyFile option of shrinkfile is only relevant to data files. Specifying the option when shrinking log files has no effect whatsoever. You cannot move the active portion of the log with a shrink file and you cannot delete a log file that contains any portion of the active log.

    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