Luis Cazares (7/16/2013)
What about using simple recovery model? Am I confused here?
He's asking (afaict) for reasons not to truncate the log. In simple recovery, the log is automatically truncated, so the opposite.
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