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 9, 2010 9:47 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, May 9, 2012 4:22 PM
Points: 188, Visits: 76
janki_2886 (11/9/2010)
This was Question Direct from BOL, I have used same sentence as in BOL, Do you still think, its a grammer mistake.


There are hundreds of statements you could cut and paste from BOL, that doesn't make them a good QotD.
Also, please don't start a grammar debate.

But either way, i thank the author and those that posted comments as i learned something today, i was not aware that you can't take a snapshot of a system database. (Not knowing that helped me click true )
Post #1018367
Posted Wednesday, November 10, 2010 12:13 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, March 6, 2014 1:05 PM
Points: 1,334, Visits: 3,068
janki_2886 (11/9/2010)
@OLD Hand : If its a dumb question, then why are you wasting your precious time , in the discussion


So peope will take careful pause the next time they post a question taken right from BOL, as we all have to do, and realize that just because something is posted literally in BOL at one point in the article does not automatically mean that it is always 100% correct, applicable, or suitable for the QOTD as stated in BOL. This is where a little research and forethought comes in handy beforehand. For example, the statement you provided from BOL does say that in a NOTE early in the article. However, if you would have read a little further down, that earlier note has a caveat to it with this statement "Snapshots of the model, master, and tempdb databases are prohibited. " BOL now amends this earlier note with this exception regardless of the recovery model. BOL does this kind of stuff all the time. IMHO, what BOL should have accurately stated in that earlier note was "All recovery models for all user and the msdb databases support database snapshots." This is why it is so important that the entire article be taken in to context when reading or quoting BOL.


"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ..."
Post #1018388
Posted Wednesday, November 10, 2010 5:40 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Tuesday, May 8, 2012 7:53 AM
Points: 101, Visits: 349
@OLD Hand: My Only intention, was to post a easy question(which , according to u was a dumb question),so that everyone can answer that. Not all of them are as genius as you. Apart From this I did provided resource to refer too. This was my very first post and i don't think i have choose a wrong question or bad answer options.
Sometimes, Knowing So much makes a easy question, most difficult one.
What if the same question was asked in any of the certifications exams??
There is No Such Rule: To Put a hard question or not to put any question directly from BOL. If it would have been they would have not publish question or just rejected this question when i posted it.
Post #1018504
Posted Wednesday, November 10, 2010 6:31 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Sunday, July 20, 2014 11:20 PM
Points: 13,252, Visits: 10,133
janki_2886 (11/10/2010)
@OLD Hand: My Only intention, was to post a easy question(which , according to u was a dumb question),so that everyone can answer that. Not all of them are as genius as you. Apart From this I did provided resource to refer too. This was my very first post and i don't think i have choose a wrong question or bad answer options.
Sometimes, Knowing So much makes a easy question, most difficult one.
What if the same question was asked in any of the certifications exams??
There is No Such Rule: To Put a hard question or not to put any question directly from BOL. If it would have been they would have not publish question or just rejected this question when i posted it.


Just a side mark:

old hand is not the person's nickname. It is a status derived from the number of points the person has on this website (points for answering QotD + points for forum posts). Your status for example is Valued Member, for the moment. If you refer to Old Hand, we have no idea to who you are actually referring to.

The actual nickname is above this status, or if there is a picture, above the picture, displayed in bold. Thus, the real nickname of "Old Hand" is TravisDBA.




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 #1018543
Posted Wednesday, November 10, 2010 7:15 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
TravisDBA (11/10/2010)
[quote]
So peope will take careful pause the next time they post a question taken right from BOL, as we all have to do, and realize that just because something is posted literally in BOL at one point in the article does not automatically mean that it is always 100% correct, applicable, or suitable for the QOTD as stated in BOL.


Travis? really? Do you beat you children with that whip also?
Nice way to treat the new guy. Can't wait till your next QOTD.
I think I can see the flames from here already....
Post #1018586
Posted Wednesday, November 10, 2010 8:07 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, March 6, 2014 1:05 PM
Points: 1,334, Visits: 3,068
SanDroid (11/10/2010)
TravisDBA (11/10/2010)
[quote]
So peope will take careful pause the next time they post a question taken right from BOL, as we all have to do, and realize that just because something is posted literally in BOL at one point in the article does not automatically mean that it is always 100% correct, applicable, or suitable for the QOTD as stated in BOL.


Travis? really? Do you beat you children with that whip also?
Nice way to treat the new guy. Can't wait till your next QOTD.
I think I can see the flames from here already....


You're missing the point. My point is don't take individual single BOL statements literally. You have to read the whole article first and take the entire article in context before posting a possible misleading and confusing question to QOTD. That applies to everyone, not just one person, regardless of number of posts a person has.


"Technology is a weird thing. It brings you great gifts with one hand, and it stabs you in the back with the other. ..."
Post #1018644
Posted Wednesday, November 10, 2010 8:16 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
There is no grey area on this.
As far as recovery models are concerned the are all supported by DB snapshot.

This IS a question on the MS SQL DBA exam and you would have missed it if you marked it anything other than True.

Get a grip Travis and stop trying to confuse others into making mistakes on simple easy answers.
Post #1018648
Posted Wednesday, November 10, 2010 9:48 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 16, 2014 9:38 AM
Points: 2,163, Visits: 2,189
I agree that the question is good, and TRUE is the correct answer. The question is "All Recovery Models support Database Snapshots." which is true, as they do. However not all databases support database snapshots.

The question wasn't "You can create a database snapshot of any database regardless of the recovery model." or "All Databases support Database Snapshots."
Post #1018759
Posted Thursday, November 11, 2010 2:25 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, July 18, 2014 12:37 AM
Points: 132, Visits: 202

for more info :

http://msdn.microsoft.com/en-us/library/ms189940.aspx
Post #1019162
Posted Monday, November 15, 2010 5:50 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 10:00 AM
Points: 8,551, Visits: 9,043
This was a good question, with a clearly correct answer.

All the suggestions that "none of the above" is the correct answer surprised me, and the absolutely illogical arguments supporting that position surprised me even more. It seems to me that people fell into an obvious error, and did itsolely because they were looking for a non-existent trick in the question: multivalued logics are far better than two valued logics in many circumstances, but you have to decide what the values other than "true" and "false" mean and if you don't have meanings for those values you don't have a meaningful multivalued logic - and it seems quite clear from the arguments presented that there was no attempt to assign any particular meaning to any truth value that was "none of the above".

It might be arguable that because the recovery model has nothing to do with supporting database snapshots the correct answer should be "false" because it is not the recovery model that actually supports it but something else, but it is absolute nonsense to conclude that because there are some databases which don't permit database snapshot the correct answer is neither "true" nor "false".



Tom
Post #1020684
« Prev Topic | Next Topic »

Add to briefcase «««12345»»

Permissions Expand / Collapse