homebrew01 (4/6/2013)
I have a 55 Gig database, and the differential backup for yesterday was 32 Gig !! It was about 5 gig the day beforeSo, I assumed I could look at my transaction log backups and find a huge T-log backup to identify what time of day something big happened. But my t-logs, every 15 minutes, show 1 backup > 1 gig, and all the others quite small, and similar to other days this week.
What can make a huge Diff backup, without generating huge t-log backup(s) ?
T-Log backups that occur every 15 minutes happen 96 times a day. If you divide 32 by 96, the average T-Log size is only 0.3333.
--Jeff Moden
Change is inevitable... Change for the better is not.