DB Recovery

  • smthembu

    Hall of Fame

    Points: 3459

    Comments posted to this topic are about the item DB Recovery

    It's better to fail while trying, rather than fail without trying!!!

  • Shaun McGuile

    SSCarpal Tunnel

    Points: 4111

    Easy 2 points - see dec 11 QoTD 😀

    THough not exactly the same question it is very similar.

    It was 2008 in that one, this one is 2005.

    --Shaun

    Hiding under a desk from SSIS Implemenation Work :crazy:

  • Andrew Watson-478275

    SSCarpal Tunnel

    Points: 4652

    Since the question states "...using the log backups", and there can't be any in Simple mode, my reasoning was that the correct answer has to be "none of the above". Answering "No" implies that there are log backups, but that you can't recover from them.

    I know that this is arguing semantics a bit, but what's the point of a none of the above if it's meaningless?

  • ta.bu.shi.da.yu

    Hall of Fame

    Points: 3985

    Andrew Watson (12/17/2008)


    Since the question states "...using the log backups", and there can't be any in Simple mode, my reasoning was that the correct answer has to be "none of the above". Answering "No" implies that there are log backups, but that you can't recover from them.

    I know that this is arguing semantics a bit, but what's the point of a none of the above if it's meaningless?

    Well, if there is a log backup only from the point after the 1000 records are updated/inserted then the answer can ONLY be no, because you couldn't restore from the only log file you have.

    But yeah, that choice and the way the question was phrased leaves a bit to be desired.

    Random Technical Stuff[/url]

  • Andrew Watson-478275

    SSCarpal Tunnel

    Points: 4652

    No, there isn't a log backup, only a log.

  • ta.bu.shi.da.yu

    Hall of Fame

    Points: 3985

    Good point. I concede the point!

    Question was badly asked.

    Random Technical Stuff[/url]

  • Ralf Dietrich

    SSChasing Mays

    Points: 651

    as I would say:

    " ... Can I recover using the log backups? "

    You do not have any log backups!

    If so - it implies that you have a fresh full backup after changing the recovery mode and than the correct answer was yes.

    but this make no sense: answer c) "none of the above" should be correct - You do not have any log backups! :w00t:

  • Nicholas Cain

    SSC-Dedicated

    Points: 33009

    I agree with the C. There is no mention of a log backup ever being performed, therefore a restore using log backups does not fall within the scope of yes or no.



    Shamless self promotion - read my blog http://sirsql.net

  • Anipaul

    SSC-Insane

    Points: 24681

    Easy one ...

  • StarNamer

    SSCrazy Eights

    Points: 8633

    Following the earlier discussion, I too went for (C) since there is no mention of when any log backups were done, so you don't know if there are any or how successfull they wer, hence cannot answer either yes or no.

    Derek

  • jaanureddy

    Grasshopper

    Points: 14

    From my side ans is 'C'

  • BuntyBoy

    SSCommitted

    Points: 1876

    Since no backup is taken after changing the recovery model / after inserting records.. so no way you can recovery any data in this DB....

    I believe something is missing in the question 😉

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

  • TomThomson

    SSC Guru

    Points: 104773

    Good question.

    I don't understand why several people appear to thenk that the answer to "can you recover using the log backups that you do not possess" is not "no".

    Tom

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

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