January 24, 2018 at 3:33 am
We have this setup in my organization Recovery = simple
Fullbackup = sunday 12am
Diff = mon to sat 12am
I understand a diff backup is some changes after the last full backup.My organization wants diff backup to be done twice a day at 12pm and 12am as usual.
My question - This second backup,will it contain changes from last diff only or its last diff plus new changes?
I hope my question is clear.
Thank you
January 24, 2018 at 3:35 am
It will contain all the changes from the last full backup. If you need to restore your database you will need to restore the full backup plus the most recent differential.
Thanks
January 24, 2018 at 4:39 am
tmmutsetse - Wednesday, January 24, 2018 3:33 AMWe have this setup in my organization Recovery = simple
Fullbackup = sunday 12am
Diff = mon to sat 12am
I understand a diff backup is some changes after the last full backup.My organization wants diff backup to be done twice a day at 12pm and 12am as usual.
My question - This second backup,will it contain changes from last diff only or its last diff plus new changes?
I hope my question is clear.Thank you
The preceding answer is accurate (+1), but to be as clear as possible, it's that second thing, "last diff plus new changes". Each differential is cumulative since the last full backup (not counting COPY_ONLY backups).
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply