Home Forums SQL Server 2005 T-SQL (SS2K5) Transaction Log Growing Despite Simple Recovery RE: Transaction Log Growing Despite Simple Recovery
Lynn Pettis
SSC Guru
Points: 442467
More actions
April 19, 2010 at 1:46 pm
#1154128
Here is a guess at why you see a larger growth from stage to production than from source to stage: indexes on the production table(s). Do you currently drop and recreate the indexes or are they in place during the transfer?