There was a question and answer from someone who actually worked on the SQL development team where they gave a long list of reasons why not to truncate an MSSQL Log file (it had something to do with index fragmentation).

Does anyone know what this question was? I've been searching for ages and I can't find it!

  • My guess is it was from Paul Randal. He use to run the dev team for the storage engine. I'll look and see if I can find it. Have a look through Paul's blog, though. Tons of good stuff there including why it's bad news to truncate a log file. sqlskills.com/blogs/paul
    – squillman
    Sep 13, 2010 at 4:14

1 Answer 1


Any of these what you're looking for? They're Paul Randal's posts that include 'truncate'.



You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .