Post reply

Backup Types

  • October 7, 2010 at 9:50 pm

    #227753

    Comments posted to this topic are about the item Backup Types

    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.

  • October 7, 2010 at 9:50 pm

    #1234011

    Nice question, thanks!

  • October 7, 2010 at 10:06 pm

    #1234018

    Nice question "Brandie Tarvin". Incremental is in Windows backup types & Differential is in SQL Backup types so its a googly ball 🙂

    Thanks

  • October 8, 2010 at 1:12 am

    #1234041

    Interesting. I've never heard of a partial backup, and am struggling to figure out how it would be useful...will have to do some research!

  • October 8, 2010 at 2:27 am

    #1234064

    Good question. I answered it wrong even though I knew the correct answer. What fooled me was the incremental backup. I know there is nothing called an incremental backup, but I have also seen that transaction log backups sometimes are referred to as a kind of incremental backup, so I though "is this a trick question?". Lesson learned: always trust my initial instinct.

  • October 8, 2010 at 5:42 am

    #1234160

    Partial Backup caught me out on this one, had the others. So there's a "learning opportunity" for me. 😉

  • October 8, 2010 at 7:01 am

    #1234220

    Argh! (Is it talk like a pirate day?)

    Too much time as a windows admin, incremental backup. Partial backup is a new one on me. Good question, thanks.

  • October 8, 2010 at 12:03 pm

    #1234431

    I'm glad the question has helped so many people. I did not realize how few people knew about File and Partial backups.

    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.

  • October 8, 2010 at 12:29 pm

    #1234462

    Thanks for the question Brandie.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • October 10, 2010 at 4:56 am

    #1234685

    Nice question as far as it goes.

    But it would have been nice to go a bit further and have a few more backup types, a list like

    Database backup

    Differential database backup

    Partial backup

    Differential partial backup

    File backup

    Differential file backup

    Log backup

    (plus of course incremental backup and maybe more spurious ones)

    so that it's clear that the Database/Partial/File distinction is orthogonal to the Full/Differential distinction, giving 6 possibilities plus the log backup to make 7.

    And then does WITH Copy Only introduce some more types and if so how many - but maybe that could be a separate QotD.

    Tom

  • October 10, 2010 at 10:16 pm

    #1234767

    Thanks Tom Thomson for all backup types.

    Thanks

  • October 15, 2010 at 10:04 am

    #1237665

    I have never used Incremental backup but I kind of remember reading somewhere about it as a new addition to SQL 2005 when it first came out. I never went back to dig into it as I care much less about this new backup feature as I was not going to use it anytime soon but it was somewhere in the back of my head that it is there if I happen to need it in future.

    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.

  • 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.

  • October 19, 2010 at 1:08 am

    #1238847

    Nice Question. logged back after a long time and got it wrong. :sick:

  • October 20, 2010 at 12:14 am

    #1239489

    I guess incremental Back up was there only in oracle 🙂

Viewing 15 posts - 1 through 15 (of 17 total)

You must be logged in to reply to this topic. Login to reply