• 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:

    He didn't use TRUNCATE_ONLY as part of a BACKUP command, he used it in a DBCC SHRINKFILE--I can't find any mention that using it in that way is deprecated.