Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Brandie Tarvin Backup Types RE: Backup Types

  • October 15, 2010 at 10:19 am

    #1237677

    JustStarted (10/15/2010)

    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: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.