<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Janki Patel
»
Database Snapshot
43 posts, Page 4 of 5
««
«
1
2
3
4
5
»»
Database Snapshot
Rate Topic
Display Mode
Topic Options
Author
Message
lukus_g
lukus_g
Posted Tuesday, November 09, 2010 9:47 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, May 09, 2012 4:22 PM
Points: 187,
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
TravisDBA
TravisDBA
Posted Wednesday, November 10, 2010 12:13 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, May 09, 2013 9:23 AM
Points: 1,288,
Visits: 2,996
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
janki
janki
Posted Wednesday, November 10, 2010 5:40 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, May 08, 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
Koen Verbeeck
Koen Verbeeck
Posted Wednesday, November 10, 2010 6:31 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 9,378,
Visits: 6,473
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
SanDroid
SanDroid
Posted Wednesday, November 10, 2010 7:15 AM
Ten 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
TravisDBA
TravisDBA
Posted Wednesday, November 10, 2010 8:07 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, May 09, 2013 9:23 AM
Points: 1,288,
Visits: 2,996
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
SanDroid
SanDroid
Posted Wednesday, November 10, 2010 8:16 AM
Ten 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
UMG Developer
UMG Developer
Posted Wednesday, November 10, 2010 9:48 AM
SSCrazy
Group: General Forum Members
Last Login: Monday, May 13, 2013 11:21 AM
Points: 2,163,
Visits: 2,148
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
pravin wagh
pravin wagh
Posted Thursday, November 11, 2010 2:25 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Monday, November 26, 2012 4:40 AM
Points: 129,
Visits: 123
for more info :
http://msdn.microsoft.com/en-us/library/ms189940.aspx
Post #1019162
L' Eomot Inversé
L' Eomot Inversé
Posted Monday, November 15, 2010 5:50 AM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 12:25 PM
Points: 7,110,
Visits: 7,184
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
Is minic a gheibheann béal oscailte dorn dúnta.
Is minig a cheapas beul fosgailte dòrn dùinte.
Post #1020684
« Prev Topic
|
Next Topic »
43 posts, Page 4 of 5
««
«
1
2
3
4
5
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
