incremental vs differential backup in SQL Server

3

Whenever I need to configure the backup routine of a SQL Server database I confuse these two types of backup. So I'd like to know:

  • What does each one do?
  • Given that I do a full backup on Sunday, when I have to restore a database do I have to restore each of the files?
asked by anonymous 15.03.2017 / 18:07

1 answer

3

As you said, make a full backup on Sunday, we'll start from this scenario.

When you do an incremental backup on Tuesday, it will have the data you were changed in the second and you make another in the fourth that will have the data altered on Tuesday and so on.

A differential backup on Tuesday, for example, would have no incremental difference, but a differential backup on the sixth would have all the changes occurring in the week and would equal the sum of all incremental backups.

Similarly, if you do an incremental backup on Friday it would be no different from a differential backup also done on Friday.

To restore would have two paths. Restore the full backup of Sunday and all the incrementals made during the week or Sunday full and the sixth differential, of course, depending on the method of backups you have chosen.

    
15.03.2017 / 18:41