<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 Duncan Pryde
»
Point-in-time restore
44 posts, Page 2 of 5
««
1
2
3
4
5
»
»»
Point-in-time restore
Rate Topic
Display Mode
Topic Options
Author
Message
Daniel Bowlin
Daniel Bowlin
Posted Wednesday, February 16, 2011 8:26 AM
SSCrazy
Group: General Forum Members
Last Login: Wednesday, May 22, 2013 1:10 PM
Points: 2,673,
Visits: 2,418
It is always a good question when I have to do a little reading to get the answer. Thanks.
Post #1065040
Patrick2525
Patrick2525
Posted Wednesday, February 16, 2011 8:29 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Monday, April 01, 2013 10:16 AM
Points: 117,
Visits: 180
Well, thanks for the clarification. I was studying for the MCTS exam using 'The Real MCTS SQL Server 2008 Exam 70-432 Prep Kit: Database Implementation and Maintenance' by Mark Horninger (2009) which stated it clear as mud:
The Bulk-Logged recovery model is similar to Full recovery model, except that nonlogged operations are performed as nonlogged. This provides a performance advantage for Bulk-Logged operations. However, if a Bulk-Logged operation has occurred since the last full backup, you will not be able to recover any changes made since the last full backup.
The Bulk-Logged recovery model does not support point-in-time recovery
.
Post #1065042
SQL-DBA-01
SQL-DBA-01
Posted Wednesday, February 16, 2011 11:31 AM
Right there with Babe
Group: General Forum Members
Last Login: 2 days ago @ 1:33 AM
Points: 738,
Visits: 1,126
Was really the question framed correctly?
Thanks.
Post #1065166
Duncan Pryde
Duncan Pryde
Posted Wednesday, February 16, 2011 11:34 AM
Hall of Fame
Group: General Forum Members
Last Login: Yesterday @ 5:04 AM
Points: 3,046,
Visits: 1,309
Patrick2525 (2/16/2011)
Well, thanks for the clarification. I was studying for the MCTS exam using 'The Real MCTS SQL Server 2008 Exam 70-432 Prep Kit: Database Implementation and Maintenance' by Mark Horninger (2009) which stated it clear as mud:
The Bulk-Logged recovery model is similar to Full recovery model, except that nonlogged operations are performed as nonlogged. This provides a performance advantage for Bulk-Logged operations. However, if a Bulk-Logged operation has occurred since the last full backup, you will not be able to recover any changes made since the last full backup.
The Bulk-Logged recovery model does not support point-in-time recovery
.
Wow - that's wrong on two counts. First is that even if bulk-logged operations have occurred since the full backup, you can still recover to the end of a log backup, and second is the bit you highlighted.
Although I haven't done that exam myself as I upgraded directly from 2005 to 2008 MCITP, most of the Admin exams I've done have contained a fair amount of backup and recovery questions, so it does pay to know your stuff.
Duncan
Post #1065167
Duncan Pryde
Duncan Pryde
Posted Wednesday, February 16, 2011 11:37 AM
Hall of Fame
Group: General Forum Members
Last Login: Yesterday @ 5:04 AM
Points: 3,046,
Visits: 1,309
Sourav-657741 (2/16/2011)
Was really the question framed correctly?
Can you be more specific?
Duncan
Post #1065172
Patrick2525
Patrick2525
Posted Wednesday, February 16, 2011 11:45 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Monday, April 01, 2013 10:16 AM
Points: 117,
Visits: 180
Yes, it's very frustrating trying to study for the exams when the study guides are wrought with errors and contradictions. I wish those things were peer reviewed. However, these SSC QOTD, along with the peer discussions, keeps me on my toes
Post #1065179
UMG Developer
UMG Developer
Posted Wednesday, February 16, 2011 11:55 AM
SSCrazy
Group: General Forum Members
Last Login: Monday, May 13, 2013 11:21 AM
Points: 2,163,
Visits: 2,148
Great question, covering this type of information is very valuable. thanks!
Post #1065190
Duncan Pryde
Duncan Pryde
Posted Wednesday, February 16, 2011 11:56 AM
Hall of Fame
Group: General Forum Members
Last Login: Yesterday @ 5:04 AM
Points: 3,046,
Visits: 1,309
Patrick2525 (2/16/2011)
Yes, it's very frustrating trying to study for the exams when the study guides are wrought with errors and contradictions. I wish those things were peer reviewed. However, these SSC QOTD, along with the peer discussions, keeps me on my toes
I must warn you though - it can become addictive. I've been slowly working my way through all the previous questions from the beginning. I've only got a few hundred more to go...
Post #1065192
SanDroid
SanDroid
Posted Wednesday, February 16, 2011 12:54 PM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,232,
Visits: 1,046
Patrick2525 (2/16/2011)
Yes, it's very frustrating trying to study for the exams when the study guides are wrought with errors and contradictions. I wish those things were peer reviewed. However, these SSC QOTD, along with the peer discussions, keeps me on my toes
True Story: The exam questions are filled with contradictions and odd errors also. They are peer reviewed (no really) a lot like these questions are. We would sometimes agree to leave in a "bad" question. One or two individuals would bother or Flame the rest of the panel until frustration, instead of logic, made the decision. That is why I have always recomended the use of "study guides" to anyone taking the certification tests.
IMHO: The best ones out there are Troy...
Post #1065243
SanDroid
SanDroid
Posted Wednesday, February 16, 2011 12:55 PM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,232,
Visits: 1,046
Thanks for the super easy question and the Super easy two points!
Post #1065245
« Prev Topic
|
Next Topic »
44 posts, Page 2 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.
