Home Forums SQL Server 2005 T-SQL (SS2K5) Transaction log growing huge if DB is in simple recovery model RE: Transaction log growing huge if DB is in simple recovery model

  • You could shrink the LOG file when this has grown by a large one-time action. But if this (kind of) action is periodically recurring the LOG will grow back to the current size.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **