Database Snapshot

Question

Post reply

Database Snapshot

July 15, 2011 at 6:17 am

This was removed by the editor as SPAM

Viewing 15 posts - 16 through 30 (of 57 total)

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

Kwex Default port Points: 1407 More actions · Answer 1

<<Question of the day>>

Database snapshots are available in which SQL Server 2008 R2 editions. Select 2.

Sorry - you were wrong

Correct answer:

Standard, Enterprise

Explanation:

In SQL Server 2008 R2, database snapshots are only supported in Enterprise and Data Center editions.

Ref: Features Supported by the Editions of SQL Server 2008 R2 - http://msdn.microsoft.com/en-us/library/cc645993.aspx

Join the discussion about this question

Contribute a question of your own

<</Question of the day>>

Thought something was wrong with my eyes when I saw "Sorry you were wrong"! This is an unusual case where the answer differs from the explanation 🙂

Points back pls!

Kwex.

cengland0 SSCertifiable Points: 6102 More actions · Answer 2

Thank goodness I'm not the only one this time. This one was so easy I almost had heart failure when it said I got it wrong. Luckily there was a flaw in the programming of the QOTD instead.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

cengland0 (7/15/2011)
Thank goodness I'm not the only one this time. This one was so easy I almost had heart failure when it said I got it wrong. Luckily there was a flaw in the programming of the QOTD instead.

I can imagine your face when it said you were wrong 😀

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

karl.gjertsen Valued Member Points: 72 More actions · Answer 4

I'm glad I'm not the only one who was confussed!

Please can I have my points?

Richard Warr SSCertifiable Points: 6966 More actions · Answer 5

I was so outraged that it said I had got this question wrong that I threw a brick through my screen and sent SQLServerCentral the bill.

I then noticed that the error had already been pointed out so decided to point it out again 😉

cengland0 SSCertifiable Points: 6102 More actions · Answer 6

Koen Verbeeck (7/15/2011)
cengland0 (7/15/2011)
Thank goodness I'm not the only one this time. This one was so easy I almost had heart failure when it said I got it wrong. Luckily there was a flaw in the programming of the QOTD instead.
I can imagine your face when it said you were wrong 😀

Ha, you're right. Perhaps I take these QOTD's too seriously. I used to be OCD until I got addicted to these great pills that help me not care as much but I still have the tendencies to worry about missing these questions. Maybe I need a stronger dose of my chill-pills.

call.copse SSCoach Points: 18048 More actions · Answer 7

I was so cross with that I smashed up my PC, battered the silicon chips inside, fried them up and ate them with a nice chianti.

I am even more annoyed because I legitimately got a few wrong recently through poor reading comprehension so my scores are a bit down 🙁

eric_van_uden Say Hey Kid Points: 705 More actions · Answer 8

http://msdn.microsoft.com/en-us/library/ms190677.aspx is clear enough on the subject, but I went with the info on http://msdn.microsoft.com/en-us/library/cc645993.aspx: "Database snapshots, introduced in SQL Server 2005, are available only in the Enterprise editions of SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2." I knew it was in the Datacenter, really, but was still compelled by the force of that MS-statement. And got it totally wrong as a result, of course. Could I ask MS to reinstate me for this point as well, or do I need to post forum messages to make up the balance? :hehe:

rfr.ferrari SSCertifiable Points: 6879 More actions · Answer 9

well, forsqlserver!!!

you posted, correct documentation but incorrect answer!!!!

[font="Times New Roman"]rfr.ferrari[/font]
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
the period you fastest growing is the most difficult period of your life!

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

i know we are all human and we all make mistakes but something as easy as this shouldn't really slip through the net.

hope they resolve and redistribute the points

Thomas Abraham SSChampion Points: 10761 More actions · Answer 11

stewartc-708166 (7/15/2011)
To add a slighly different spin on things - I'm sure people learned something, as they will have done a bit of homework to make sure of their answers when it showed up as incorrect.
So, the aim and spirit of QotD (viz. to learn something new, or refresh knowledge already gained) is achieved.

If that's true, then wouldn't it be better if they gave the wrong answer every day! :hehe:

Seriously, I'm only posting this to get the point back for having had a correct answer marked incorrect. 😉

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

kapfundestanley SSCertifiable Points: 5637 More actions · Answer 12

Anyone who knows who contributed the question and answers?

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

rgtft Hall of Fame Points: 3518 More actions · Answer 13

It looks like a mistake again in the QOTD. Point please, as I checked Enterprise and DataCenter (which is correct)

Thanks,

Rob

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 14

kapfundestanley (7/15/2011)
Anyone who knows who contributed the question and answers?

Probably the guy/girl who started this thread?

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