Alvin Ramard (6/8/2015)
spaghettidba (6/8/2015)
You don't need all the differentials since the last full, just the latest one.This is what you need:
1. Last full backup
2. Last differential
3. All the log backups taken after the differential
Restoring just the last differential doesn't sound correct to me.
It is correct. Differentials contain all changes since the full that they're based on, hence it's a pointless waste of time to restore multiple diffs one after the other (though you can do it)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability