Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12345»»»

Database Snapshot Expand / Collapse
Author
Message
Posted Tuesday, November 09, 2010 3:30 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 3:08 AM
Points: 785, Visits: 1,259
I do agree with "england0".

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


Thanks.
Post #1017724
Posted Tuesday, November 09, 2010 4:23 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:35 AM
Points: 12,208, Visits: 9,172
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1017749
Posted Tuesday, November 09, 2010 5:23 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 08, 2012 7:53 AM
Points: 101, Visits: 349
Sir,
There Were People Who Selected, "None Of the above" Option.
Thinking, putting third option was a joke, is a joke itself.('');
At least I Tried !!
Post #1017780
Posted Tuesday, November 09, 2010 7:27 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, April 10, 2014 3:42 AM
Points: 890, Visits: 1,179
Nice & Easy question.

Thanks
Post #1017912
Posted Tuesday, November 09, 2010 7:28 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, May 21, 2012 3:13 PM
Points: 516, Visits: 1,563
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



Post #1017914
Posted Tuesday, November 09, 2010 7:32 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 24, 2013 9:59 PM
Points: 1,354, Visits: 1,299
steve block (11/9/2010)
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

Thanks Steve. I suppose my beef is that too many of these QOTD's are trick questions and you have to think of every possibility and this time I did it properly and selected the None of the Above and got it wrong. I think that was unfair because the answer I selected, for the same reason you mentioned, is a better answer than just selecting "True" because you cannot snapshot the system databases.
Post #1017919
Posted Tuesday, November 09, 2010 8:25 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, April 17, 2014 11:58 AM
Points: 3,924, Visits: 1,588
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).


Hugo, 24 out of 600 (4%) replies did choose none of the above option.

So, putting this option is now justified.


SQL DBA.
Post #1017970
Posted Tuesday, November 09, 2010 8:39 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,232, Visits: 1,046
cengland0 (11/9/2010)
[quote] 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."


This is why the ESP of the day was ruining the Question of the Day. Now people are selecting the wrong answer for an easy question because they are looking for the grammer mistake or the "trick".

BTW: I read the books online and the exact same sentance is there that is in the question.

Note
All recovery models support database snapshots.



Post #1017988
Posted Tuesday, November 09, 2010 8:49 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,232, Visits: 1,046
I almost forgot!

I give this question fife stars for knot havings any type o's and shows correct referance meaterials and knowledge of feartures.

I give it an extra star for the inclusion of the "None Of the Above" selection.
Genious!
Post #1017999
Posted Tuesday, November 09, 2010 9:27 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 08, 2012 7:53 AM
Points: 101, Visits: 349
This was Question Direct from BOL, I have used same sentence as in BOL, Do you still think, its a grammer mistake.
Post #1018025
« Prev Topic | Next Topic »

Add to briefcase ««12345»»»

Permissions Expand / Collapse