I read somewhere on online posting, long time ago that Incremental Backup backs up database since the last full backup and the last incremental backup whereas Differential Backup backs up database since the last full backup.
Nope. Sorry. Lots of people call Transaction Logs by the name Incremental, which unfortunately persists the myth. It's a bad name to call it since Incremental really does exist for other software products.
EDIT: Just a note. Transaction Logs do not behave the way you've listed Incrementals as behaving. It's similar behavior, but you need every Transaction Log up to the most current or your P.I.T. in order to properly restore the database.
Incremental just doesn't exist for SQL Server. See my SQL Misconceptions post
for T-SQL Tuesday this month.
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog
, and Twitter
.Freelance Writer: ShadowrunLatchkeys: Nevermore
, Latchkeys: The Bootleg War
, and Latchkeys: Roscoes in the Night
are now available on Nook and Kindle.