Home Forums Article Discussions Article Discussions by Author Discuss content posted by Simon Facer Why SHRINKFILE is a very bad thing, and what to do about it. RE: Why SHRINKFILE is a very bad thing, and what to do about it.

  • November 9, 2010 at 1:50 am

    #1248071

    Joshua T. Lewis-378876 (11/9/2010)

    Simon,

    Just as an FYI, Microsoft has depreciated the TRUNCATE_ONLY option in SQL 2008, and you have to use a different option in the BACKUP LOG command:

    BACKUP LOG <database> TO DISK='NUL:'

    The replacement for Backup log ... truncate only is a switch to simple recovery model, not a backup to the nul device.

    A backup to the nul device is completely equivalent to taking a log backup and then deleting the backup file. It is NOT a replacement for backup log ... truncate only and quite honestly I would question the logic of anyone using that

    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