When I go into the SSMS UI I see two types of backup one is full and other is differential. My understanding is that differential is all the data since the last full.
So in case of restore on Thurday I should apply
Full + Diff (Wednesday) + TLOG
Now my colleagues keep referring to something called as "incremental" which they say is a daily backup So in case of a restore you apply
full + incremental(Monday) + incremental(Tuesday) + incremental (Wednesday) + TLOG
However the UI has no notion of this .... can you give me more details of this incremental.... is this a feature of some other database?
View Complete Post