3
Whenever I need to set up the backup routine of an SQL Server database I confuse these two types of backup. Therefore I would like to know:
3
As you said you do a full backup on Sunday, let’s take it from this scenario.
When you take an incremental backup on Tuesday, it will have the data that were changed on Monday and you do another on Wednesday that will have the data amended on Tuesday and so on.
A differential backup on Tuesday, for example, would have no difference from the incremental, but a differential backup on Friday would have all the changes that occurred in the week and would equal the sum of all incremental backups.
Similarly, if you do an incremental backup on Friday would be no different than a different backup also done on Friday.
To restore would have two paths. Restore Sunday’s full backup and all incrementals made during the week or Sunday’s full and Friday’s differential, of course, depending on the method of backups you chose.
Browser other questions tagged sql-server backup
You are not signed in. Login or sign up in order to post.
for easy memorization: the DIFFERENTIAL contains everything that is DIFFERENT between the current bank and the full backup right? my backup routine is wrong so, I am doing incremental but overwriting the file, I will never be able to restore completely this way.
– Washington da costa
Making incremental you need to save all until the next full backup.
– Reginaldo Rigo