Alas Poor Snapshot, I Knew Him Well

Question

Post reply

Alas Poor Snapshot, I Knew Him Well

Andy Warren

SSC Guru

Points: 119902
More actions
March 19, 2014 at 8:59 pm

#146664

Comments posted to this topic are about the item Alas Poor Snapshot, I Knew Him Well
Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
March 20, 2014 at 2:11 am

This was removed by the editor as SPAM

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

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

happycat59 One Orange Chip Points: 29387 More actions · Answer 1

happycat59

One Orange Chip

Points: 29387

March 19, 2014 at 9:00 pm

#1698564

I got to finish my lunch

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 2

lucky I didn't like my lunch....

Hope this helps...

Ford Fairlane
Rock and Roll Detective

Arthur Olcot SSCertifiable Points: 6564 More actions · Answer 3

Great quality question.. Content (and humour!) aside, the question itself actually made you think and apply logic to come up with the most likely correct answer (which we all have to do when troubleshooting) and not just know hard facts about a particular feature. One of the best qotd for a long while... Thanks..

Michael Riemer SSCertifiable Points: 5190 More actions · Answer 4

arthurolcot (3/20/2014)
Great quality question.. Content (and humour!) aside, the question itself actually made you think and apply logic to come up with the most likely correct answer (which we all have to do when troubleshooting) and not just know hard facts about a particular feature. One of the best qotd for a long while... Thanks..

+1

Great thought out question

Richard Warr SSCertifiable Points: 6963 More actions · Answer 5

I didn't know Chipotles were real places. I'd only seen them on that South Park episode. Really good question though!

Andy sql SSCrazy Eights Points: 9481 More actions · Answer 6

Good, thoughtful question and, even better, step-by-step discussion of each possible answer.

Thanks!

Nestor Jarquin SSC Veteran Points: 295 More actions · Answer 7

Very good question. Loved the wording! And an even better answer, as the explanation was very detailed.

Good way to start my day 🙂

Thanks!

robert.mcleod SSChasing Mays Points: 618 More actions · Answer 8

Great question. I did get to eat my lunch, but only after consulting books online (good thing I have an unlimited data plan!) and doing a bit of thinking.

Good way to get the Ol' brain cells in gear for the day. :satisfied:

Mike Hays SSCommitted Points: 1871 More actions · Answer 9

Good Question Andy!

Your raising the bar for all of us attempting to write a good QOTD.

RLilj33 SSCrazy Points: 2153 More actions · Answer 10

Great question. I did not get to finish my lunch, either.

Before I called you & interrupted your lunch, however, I would have reviewed what the error was (from the answer):

"Database cannot be reverted. Either the primary or the snapshot names are improperly specified, all other snapshots have not been dropped, or there are missing files."

That may have pointed me in the right direction. Then I would have done some research. Hopefully by then either I would have the solution or you would be back in the office; and you would have enjoyed your lunch uninterrupted.

Thanks -

Junior

P.S. It should be noted that I wasn't invited to lunch (I love Chipotle). Instead, I'm at the office wondering why the revert didn't work :crazy:. Upshot: I learned something very valuable that I will never forget...

Bruce Dow Ten Centuries Points: 1019 More actions · Answer 11

Great question. Made me dig into BOL and learn.

I did get to finish lunch 🙂 even though I currently have no responsibility for backups/restores.

Thanks.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 12

Nice explanation Andy

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Dana Medley SSCertifiable Points: 6764 More actions · Answer 13

Great question all the way around. I liked the content and the "real world" situation as well as the detailed explanation that was given. Unfortunately, I did not get to finish my lunch...this time. 😀

Everything is awesome!