November 8, 2010 at 8:22 pm
Comments posted to this topic are about the item Database Snapshot
November 9, 2010 at 12:25 am
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
November 9, 2010 at 1:01 am
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).
November 9, 2010 at 1:33 am
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
November 9, 2010 at 1:45 am
it is all recovery models support database snapshot
November 9, 2010 at 1:48 am
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? 😉
November 9, 2010 at 2:03 am
Maybe an attempt to introduce trinary logic? Or should the third option have been NULL? 😉
Please, do not start a discussion about NULLs. 😀
November 9, 2010 at 2:52 am
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
November 9, 2010 at 3:03 am
November 9, 2010 at 3:25 am
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."
November 9, 2010 at 3:30 am
I do agree with "england0".
The system databases are excluded from Database snapshot. Question doesn't to look like correct..!
Thanks.
November 9, 2010 at 4:23 am
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
November 9, 2010 at 5:23 am
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 !!
November 9, 2010 at 7:27 am
Nice & Easy question.
Thanks
November 9, 2010 at 7:28 am
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
Viewing 15 posts - 1 through 15 (of 42 total)
You must be logged in to reply to this topic. Login to reply