Home Forums SQL Server 2005 Backups Differential Sizes Increase After Index Rebuild RE: Differential Sizes Increase After Index Rebuild

  • JC-3113 (5/13/2013)


    HI Bob

    thanks for your input.

    here is a followup then

    should i be rebuilding my indexes before the full backup then ?

    i thought i had read somewhere to do a full backup first

    secondly, i can understand why the first differential after the full is big, but why would the succeeding differentials also bebig, since there were probably no changes at that time of night ?

    Thanks

    jim

    Because each differential backup has ALL changes to the database since the LAST full backup.