Snapshots

Question

Post reply

Snapshots

Igor Micev

SSC-Dedicated

Points: 33110
More actions
July 18, 2012 at 10:21 pm

#278049

Comments posted to this topic are about the item Snapshots
Igor Micev,My blog: www.igormicev.com
July 19, 2012 at 3:02 am

This was removed by the editor as SPAM

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

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

M&M SSC-Insane Points: 21700 More actions · Answer 1

Good question, I was not aware of this limitation.

M&M

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 2

Great question, thanks!

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 3

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.

vk-kirov SSCertifiable Points: 7686 More actions · Answer 4

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.

kapfundestanley SSCertifiable Points: 5637 More actions · Answer 5

Difficult one for me.

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

Carlo Romagnano SSC-Insane Points: 22680 More actions · Answer 6

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

Thanks.

😀

danielfountain SSCarpal Tunnel Points: 4229 More actions · Answer 7

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.

palotaiarpad SSCertifiable Points: 5617 More actions · Answer 8

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"

Gazareth One Orange Chip Points: 27737 More actions · Answer 9

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

Ant-Green SSC Guru Points: 113507 More actions · Answer 10

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.

jpentz99 Old Hand Points: 344 More actions · Answer 11

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...

kyliedude SSC-Addicted Points: 492 More actions · Answer 12

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:

kyliedude SSC-Addicted Points: 492 More actions · Answer 13

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!).:-)