Snapshots

  • Comments posted to this topic are about the item Snapshots

    Igor Micev,My blog: www.igormicev.com

  • Good question, I was not aware of this limitation.

    M&M

  • Great question, thanks!

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Good question. I over thought and picked the wrong answer. Yes, you can restore the database from any of the snapshots, you just have to delete all but the one you want to restore from before you can.

  • Weird logic. I don't understand how the answer could be "No", while in fact the database can be restored from any of the snapshots (although not with a single RESTORE DATABASE command). Seems to be pure sophistry.

  • Difficult one for me.

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • I poke the wrong answer, but I learned something new.

    Thanks.

    😀

  • Hi all,

    I got it right - more luck then judgement though.

    I am just curious of peoples views on the terminology.

    Microsoft here:

    http://msdn.microsoft.com/en-us/library/ms189281.aspx

    Seems to start of with using the term revert - but then they have to use the restore command so they start to talk about restore.

    In my view this shouldnt really be termed a restore as alone the snapshot cannot be used to restore the database (this is correct isnt it?), however if you have a database and a snapshot you can revert the database to the snapshot.

    I think this makes sense this way round - only muddied by the fact that you still have to run the restore command.

    Obviously what you dont want is some newbie doing snapshots thinking they can restore a snapshot on failure.

  • I'm not agree with the "right" answer. I can revert to any undamaged snapshot:

    Step 1: delete all other snapshot

    Step 2: revert to the selected

    The answer would be right only with the condition: "without removing the snapshots"

  • Good question. Interesting point made by some that you can, if you delete the other snapshots.

  • I also read it as being Yes as the question didnt specify needing to delete or not delete the other snapshots, so in theory Yes I can revert to any of the snapshots.

  • anthony.green (7/19/2012)


    I also read it as being Yes as the question didnt specify needing to delete or not delete the other snapshots, so in theory Yes I can revert to any of the snapshots.

    Heh - I agree - very often these questions are more of an english test, than a SQL one...

  • This was removed by the editor as SPAM

  • A lot getting this wrong - including me! Great question as it highlights what could be a significant limitation in the world of the DBA!:w00t:

  • Totally agree with your thoughts on that: There is some wording associated with not using this as a substitute for real backups. Presumably any newbie would learn about backups first in most cases (fingers crossed!).:-)

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

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