<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 smthembu
»
DB Recovery
13 posts, Page 1 of 2
1
2
»»
DB Recovery
Rate Topic
Display Mode
Topic Options
Author
Message
smthembu
smthembu
Posted Tuesday, December 16, 2008 8:06 PM
Right there with Babe
Group: General Forum Members
Last Login: Today @ 6:17 AM
Points: 772,
Visits: 729
Comments posted to this topic are about the item
DB Recovery
It's better to fail while trying, rather than fail without trying!!!
Post #620886
Shaun McGuile
Shaun McGuile
Posted Wednesday, December 17, 2008 2:33 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Thursday, October 04, 2012 9:20 AM
Points: 583,
Visits: 1,060
Easy 2 points - see dec 11 QoTD :D
THough not exactly the same question it is very similar.
It was 2008 in that one, this one is 2005.
--Shaun
Hiding under a desk from SSIS Implemenation Work
Post #621023
Andrew Watson-478275
Andrew Watson-478275
Posted Wednesday, December 17, 2008 2:48 AM
SSC Eights!
Group: General Forum Members
Last Login: Saturday, May 18, 2013 1:44 AM
Points: 953,
Visits: 1,875
Since the question states "...using the log backups", and there can't be any in Simple mode, my reasoning was that the correct answer has to be "none of the above". Answering "No" implies that there are log backups, but that you can't recover from them.
I know that this is arguing semantics a bit, but what's the point of a none of the above if it's meaningless?
Post #621027
ta.bu.shi.da.yu
ta.bu.shi.da.yu
Posted Wednesday, December 17, 2008 6:11 AM
SSC Veteran
Group: General Forum Members
Last Login: Sunday, July 03, 2011 7:09 AM
Points: 258,
Visits: 494
Andrew Watson (12/17/2008)
Since the question states "...using the log backups", and there can't be any in Simple mode, my reasoning was that the correct answer has to be "none of the above". Answering "No" implies that there are log backups, but that you can't recover from them.
I know that this is arguing semantics a bit, but what's the point of a none of the above if it's meaningless?
Well, if there is a log backup only from the point after the 1000 records are updated/inserted then the answer can ONLY be no, because you couldn't restore from the only log file you have.
But yeah, that choice and the way the question was phrased leaves a bit to be desired.
Random Technical Stuff
Post #621141
Andrew Watson-478275
Andrew Watson-478275
Posted Wednesday, December 17, 2008 6:14 AM
SSC Eights!
Group: General Forum Members
Last Login: Saturday, May 18, 2013 1:44 AM
Points: 953,
Visits: 1,875
No, there isn't a log
backup
, only a log.
Post #621147
ta.bu.shi.da.yu
ta.bu.shi.da.yu
Posted Wednesday, December 17, 2008 6:32 AM
SSC Veteran
Group: General Forum Members
Last Login: Sunday, July 03, 2011 7:09 AM
Points: 258,
Visits: 494
Good point. I concede the point!
Question was badly asked.
Random Technical Stuff
Post #621163
Ralf Dietrich
Ralf Dietrich
Posted Wednesday, December 17, 2008 7:27 AM
Old Hand
Group: General Forum Members
Last Login: Wednesday, December 21, 2011 3:09 PM
Points: 390,
Visits: 86
as I would say:
" ... Can I recover using the log backups? "
You do not have any log backups!
If so - it implies that you have a fresh full backup after changing the recovery mode and than the correct answer was yes.
but this make no sense: answer c) "none of the above" should be correct - You do not have any log backups!
Post #621212
Nicholas Cain
Nicholas Cain
Posted Wednesday, December 17, 2008 9:28 AM
SSCrazy
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 4:27 PM
Points: 2,007,
Visits: 6,040
I agree with the C. There is no mention of a log backup ever being performed, therefore a restore using log backups does not fall within the scope of yes or no.
Shamless self promotion -
read my blog http://sirsql.net
Post #621371
Anipaul
Anipaul
Posted Thursday, December 18, 2008 12:33 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Yesterday @ 6:03 AM
Points: 4,787,
Visits: 1,335
Easy one ...
Post #621822
Derek Dongray
Derek Dongray
Posted Thursday, December 18, 2008 9:15 AM
Ten Centuries
Group: General Forum Members
Last Login: Monday, May 13, 2013 2:04 AM
Points: 1,342,
Visits: 1,946
Following the earlier discussion, I too went for (C) since there is no mention of when any log backups were done, so you don't know if there are any or how successfull they wer, hence cannot answer either yes or no.
Derek
Post #622217
« Prev Topic
|
Next Topic »
13 posts, Page 1 of 2
1
2
»»
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.
