Database Snapshot

Question

Database Snapshot

Janki

Old Hand

Points: 369
More actions
November 8, 2010 at 8:22 pm

#228824

Comments posted to this topic are about the item Database Snapshot

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

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

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

Thanks for the question. Learned something today.

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

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 2

Nice, easy question.

I was wondering about the inclusion of the "none of the above" option. Was this just a joke from the question author, or will people actually choose this answer? (at this time, none have - 56% True, 44% False, 0% None of the above).

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Carlo Romagnano SSC-Insane Points: 22669 More actions · Answer 3

Hugo Kornelis (11/9/2010)
Nice, easy question.
I was wondering about the inclusion of the "none of the above" option. Was this just a joke from the question author, or will people actually choose this answer? (at this time, none have - 56% True, 44% False, 0% None of the above).

You should wait the end of day! :-D:-D

naresh.talla SSCommitted Points: 1929 More actions · Answer 4

naresh.talla

SSCommitted

Points: 1929

November 9, 2010 at 1:45 am

#1248066

it is all recovery models support database snapshot

paul.knibbs SSCoach Points: 15320 More actions · Answer 5

Hugo Kornelis (11/9/2010)
I was wondering about the inclusion of the "none of the above" option. Was this just a joke from the question author, or will people actually choose this answer? (at this time, none have - 56% True, 44% False, 0% None of the above).

Maybe an attempt to introduce trinary logic? Or should the third option have been NULL? 😉

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

Maybe an attempt to introduce trinary logic? Or should the third option have been NULL? 😉

Please, do not start a discussion about NULLs. 😀

Peter Rijs Hall of Fame Points: 3400 More actions · Answer 7

Nice question! It made me do some reading-up on a feauture I've never used so far.

Allways good to refresh those areas once in a while.

Really like the "none of the above" answer, and will chck back to see if someone actually checked that at the end of the day. 🙂

Peter Rijs
BI Consultant, The Netherlands

RichardDouglas SSCarpal Tunnel Points: 4029 More actions · Answer 8

I can't believe people have actually clicked on "None of the above" 😀

Hope this helps,
Rich

[p]
[/p]

cengland0 SSCertifiable Points: 6102 More actions · Answer 9

Hugo Kornelis (11/9/2010)
Nice, easy question.
I was wondering about the inclusion of the "none of the above" option. Was this just a joke from the question author, or will people actually choose this answer? (at this time, none have - 56% True, 44% False, 0% None of the above).

I'm one of those that selected None of the Above. That was because it has nothing to do with recovery models. The model, master, and tempdb databases are prohibited from having snapshots. That, in my opinion, means that "True" cannot be the correct answer to this question and I already know that "False" was wrong. The only other option was "None of the Above" which I thought would mean "It depends on which database."

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 10

I do agree with "england0".

The system databases are excluded from Database snapshot. Question doesn't to look like correct..!

Thanks.

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

Sourav-657741 (11/9/2010)
I do agree with "england0".
The system databases are excluded from Database snapshot. Question doesn't to look like correct..!

The question asked what the relation was between database snapshots and recovery models.

The question did not ask the relation between database snapshots and (system) databases.

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

Janki Old Hand Points: 369 More actions · Answer 12

Sir,

There Were People Who Selected, "None Of the above" Option.

Thinking, putting third option was a joke, is a joke itself.(':w00t:');

At least I Tried !!

Hardy21 SSCrazy Eights Points: 9708 More actions · Answer 13

Hardy21

SSCrazy Eights

Points: 9708

November 9, 2010 at 7:27 am

#1248280

Nice & Easy question.

Thanks

steve block SSCertifiable Points: 7698 More actions · Answer 14

I too chose None of the Above (interpreting that it meant ("it depends") because system databases are excluded from Database Snapshots. If you follow the logic that all Simple recovery model databases can have a Database Snapshot, you would infer that Master, Model and Msdb can have a Database Snapshot, which they cannot.

Steve