When does differential make sense? Because it has an overhead - it needs a FULL and a DIFF instead of just a FULL (plus trans log backups). Does this put stress on the tape backup team to track 2 backups (instead of one). is there sometimes chaos because both tapes are not available or one is overwritten.
Is there any time it does not make sense to do diff backups (because of extra overhead)
also does diff backup take 'more' time to comb through the entire DB for the changes that have taken place?
Faster Data Recovery - In a disaster scenario, it is easier to restore Full Backup + Latest Differential backup + any latest transaction log backups than restoring Full Backup + all the transaction log