Database Backup Types

  • sergey.gigoyan

    Ten Centuries

    Points: 1210

    Comments posted to this topic are about the item Database Backup Types

  • Stewart "Arturius" Campbell

    SSC Guru

    Points: 71623

    Nice one, sergey

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

  • Jeff Moden

    SSC Guru

    Points: 995703

    Stewart "Arturius" Campbell wrote:

    Nice one, sergey

    Agreed.  I'm not sure why 3 people's votes came out at a low "3".  I gave it a 5.

    The unexpected good thing about it is that the number of incorrect answers actually show a really bad thing... a lot of people don't know backups deep enough.

    To be honest, I think this would make a great pre-interview question.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • webrunner

    SSC-Dedicated

    Points: 30105

    Thanks for the instructive question - even though I got it wrong (mistakenly thought choice 4 was true).

    -- webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • crow1969

    SSCrazy

    Points: 2975

    Am I the only one who struggled with item 1 thinking "What if the previous log backup was done with COPY_ONLY?"

  • Stewart "Arturius" Campbell

    SSC Guru

    Points: 71623

    crow1969 wrote:

    Am I the only one who struggled with item 1 thinking "What if the previous log backup was done with COPY_ONLY?"

    COPY_ONLY will not break the backup chain. They can also not be used as a base for further differential backups

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

  • crow1969

    SSCrazy

    Points: 2975

    True, but a COPY_ONLY log backup will not truncate the log, which is what I was getting at.

Viewing 7 posts - 1 through 7 (of 7 total)

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