we have backup strategy weekly full backup and daily Differential backup and hourly Tlog backup.
we observed that the Differential backups are growing fast like after taking full backup on sunday, on monday the differentail backup size is 75GB and on thursday it will come to 180Gb and then on saturday around 220GB. on monday again the size will go to 75GB so just wanted to know how this happens.please guide me.
Answer by Kev Riley ·
A differential backup contains all the changes since the last full backup, so it will grow daily until you take a new full backup weekly.
A differential backup is based on the most recent, previous full data backup. A differential backup captures only the data that has changed since that full backup. The full backup upon which a differential backup is based is known as the base of the differential.