experts out there , I have a question on incremental backup related to a file not data.
my understanding is that incremental backup capture the changes from previous day and backup the file not the change data inside the file .For an example
I have a file1 , the changes on this file takes place everyday .
my backup schedules run on Sunday the full backup and rest of the days are incremental backup.
so the backup software back this file everyday , this case i pick the last day and restore it if i need to recover.
Am i correct on this?
if it is more than one files (mass restore) then i can go from last day restore but not to overwrite,that is, Friday restore and tell not to overwrite. Thursday tell not to overwrite etc go to full backup last.
or restore the full backup first then monday tell the backup to overwrite, Tuesday tell the backup to overwrite and so on.