July 19, 2012 at 1:55 pm
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?
As far as I understand there is a RESTORE command that among other things can “Revert a database to the point in time captured by a database snapshot”.
What two things? What am I missing?
--Vadim R.
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.
Viewing 15 posts - 46 through 60 (of 61 total)
You must be logged in to reply to this topic. Login to reply