Hi Team,
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.
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.
Just needed a small clarification, the data file is growing 2GB per day but the differential backup is growing 30GB. from the above comment its should grow 2gb daily as there is 2gb changes are happening. please clarify.
That's 2 different things. If your data file is growing by 2GB per day, that's 2GB of new data. The diff backup contains changes - so it could be 28GB of changes to existing data pages, and 2GB of new data
Changes in the sense it will be update or delete or insert right.
15 People are following this question.
