Post reply

DB Recovery

  • December 16, 2008 at 8:06 pm

    #216598

    Comments posted to this topic are about the item DB Recovery

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

  • December 17, 2008 at 2:33 am

    #913660

    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:

  • December 17, 2008 at 2:48 am

    #913664

    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?

  • December 17, 2008 at 6:11 am

    #913758

    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]

  • December 17, 2008 at 6:14 am

    #913765

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

  • December 17, 2008 at 6:32 am

    #913777

    Good point. I concede the point!

    Question was badly asked.

    Random Technical Stuff[/url]

  • December 17, 2008 at 7:27 am

    #913820

    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:

  • December 17, 2008 at 9:28 am

    #913956

    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

  • December 18, 2008 at 12:33 am

    #914325

    Easy one ...

  • December 18, 2008 at 9:15 am

    #914661

    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

  • August 6, 2009 at 11:57 am

    #1035564

    From my side ans is 'C'

  • September 1, 2010 at 1:33 am

    #1214772

    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]

  • December 7, 2010 at 10:00 am

    #1259662

    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 12 (of 12 total)

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