July 19, 2012 at 2:06 pm
rVadim (7/19/2012)
SanDroid (7/19/2012)
😛 Revert from a snapshot and Database Restore from a snapshot are two differant things covered by two differant BOL articles. 😛What is the difference?
.......
What two things? What am I missing?
My Gorgian sophist attitude is a start... 😉 :hehe: 😎
July 19, 2012 at 3:47 pm
As I stated earlier, I over thought the question. I actually accept that I got it wrong. I just also stated that it was still possible to revert (restore) to any of the snapshots by just deleting the ones you don't want.
Could it have been worded differently to avoid ambiguity, yes. Question is though, how often do our jobs have unambiguous events occur? We work in an environment where ambiguity is the norm.
July 19, 2012 at 7:10 pm
I agreed! We can choose any one of the snapshots to restore! It really sounds like a trick question because the focus point is on whether it is valid to restore from any of the snapshots.
Therefore, to avoid confusion, "without removing the other snapshots" or "removing all other snapshots" should be included in the choice answer, similar to that of choice three.
palotaiarpad (7/19/2012)
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"
July 19, 2012 at 8:57 pm
Grrr! The answer is clearly Yes since it is possible to restore from a snapshot (which is the question). Even if there are multiple snapshots. The only caveat is that you have to drop all snapshots but the snapshot you want to restore from.
It makes me want to stop answering questions because of these curve balls! You never know if you should take an answer literally or if you can allow for caveats.
Cheers.
July 20, 2012 at 8:13 am
Chad Crawford (7/19/2012)
I, like Luis, assumed that the reason the additional snapshots were part of the question was to direct the reader to the correct answer. That being said, I also have empathy for those who took the wording as it was stated and picked a different answer even though they completely understood the technology and situation, just misinterpreted the intention because it wasn't clear to them. There have been many times where I've looked at a QOD, seen that it could go two ways and struggled to try and guess the intent. I'm still happy to have the QOD every day regardless of whether I get it right or not and regardless of whether I feel the question was well written or not. Thank you Igor for taking the time to draw up a question, work through it, and get it published. I've done it before and it's not easy. I'm glad you did it!Thanks,
Chad
+1 (never done it before, but I certainly can imagine what it can be. thanks again)
July 23, 2012 at 4:53 am
+1
July 25, 2012 at 7:33 pm
vk-kirov (7/19/2012)
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.
You can't revert to a snapshot while there are multiple snapshots. The fact that you can delete all but one of them and then revert to that one doesn't nake you able to revert to that snapshot while you have multiple snapshots. That's not sophistry, it's just common sense.
Tom
July 27, 2012 at 5:03 pm
I agree with palotaiarpad
July 30, 2012 at 8:49 am
Lynn Pettis (7/19/2012)
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.
It was a trick question. I knew I could restore from any of the snapshots, but I had to delete all the others first.
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
July 30, 2012 at 8:55 am
L' Eomot Inversé (7/25/2012)
vk-kirov (7/19/2012)
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.You can't revert to a snapshot while there are multiple snapshots. The fact that you can delete all but one of them and then revert to that one doesn't nake you able to revert to that snapshot while you have multiple snapshots. That's not sophistry, it's just common sense.
It is common sense.
Which is also why the question is sophistry or Gorgian.
Applying that common sense rule when answering the question makes you choose the wrong answer.
Although I have heard that when taking the latest DB tests for M$ certs you should not use this common sense. 😎
July 30, 2012 at 1:25 pm
Good One.!
July 31, 2012 at 4:58 am
Easy one,thanx
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
August 8, 2012 at 11:50 am
I marked the wrong answer. :w00t:
August 28, 2012 at 3:37 am
Argh!.
Returning to some old questions, I thought I would just check out this one.
I were hazy on what I could do with snapshots, so I ended up on the referenced page and read the section "How to Revert a Database to a Database Snapshot (Using Transact-SQL)".
And Lo and behold. Reading step one I could see that I could restore any snapshot. Step two told me that a prerequisite were that I removed the rest of the snapshots. So I got it wrong 🙁
But thanks anyway. I just learned something new.
August 28, 2012 at 7:49 pm
sknox (7/19/2012)
bitbucket-25253 (7/19/2012)
Stewart "Arturius" Campbell (7/19/2012)
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.+1
Just need to delete all the other snapshots that exist before doing the restore...
Very tricksy, my precious...
+1
Agreed. I knew that you had to delete the other snapshots before restoring, but I also knew that you can delete the other snapshots and then restore. While the principle of the question is a good idea, its vagueness leads to two potential correct answers.
Since the question asks if you can restore and doesn't specifically impose any restrictions on how you go about restoring, the literal interpretation of the question as written would properly be answered "Yes, by deleting the other snapshots and then restoring."
As written, the answer is wrong.
Totally agreed with all those who got it wrong by saying "Yes". As mentioned by all, the question is not correct (or complete) and doesn't ask for the process or restrictions. Most of us who have worked with snapshots know that it is possible and hence replied "Yes".
Moderator should consider before allowing such questions with vague answers.
Viewing 15 posts - 46 through 60 (of 61 total)
You must be logged in to reply to this topic. Login to reply