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 12»»

DB Recovery Expand / Collapse
Author
Message
Posted Tuesday, December 16, 2008 8:06 PM


SSC Eights!

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

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 6:42 AM
Points: 986, Visits: 900
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
Posted Wednesday, December 17, 2008 2:33 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: Thursday, October 4, 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
Posted Wednesday, December 17, 2008 2:48 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, December 19, 2014 3:02 AM
Points: 1,298, Visits: 2,270
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
Posted Wednesday, December 17, 2008 6:11 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, July 3, 2011 7:09 AM
Points: 233, 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
Posted Wednesday, December 17, 2008 6:14 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, December 19, 2014 3:02 AM
Points: 1,298, Visits: 2,270
No, there isn't a log backup, only a log.
Post #621147
Posted Wednesday, December 17, 2008 6:32 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, July 3, 2011 7:09 AM
Points: 233, Visits: 494
Good point. I concede the point!

Question was badly asked.


Random Technical Stuff
Post #621163
Posted Wednesday, December 17, 2008 7:27 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, August 6, 2013 5:22 AM
Points: 391, Visits: 87
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
Posted Wednesday, December 17, 2008 9:28 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 12:11 PM
Points: 2,006, Visits: 6,081
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
Posted Thursday, December 18, 2008 12:33 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, December 15, 2014 4:15 AM
Points: 5,478, Visits: 1,402
Easy one ...


Post #621822
Posted Thursday, December 18, 2008 9:15 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, December 11, 2014 3:10 AM
Points: 1,274, Visits: 1,987
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 »

Add to briefcase 12»»

Permissions Expand / Collapse