Restart Log Backups

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Steve Jones » Restart Log Backups

46 posts, Page 2 of 5

««1 2 3 4 5 »»»

Restart Log Backups

Rate Topic

Display Mode

Topic Options

Author

Message

paul.knibbs

Posted Thursday, June 28, 2012 6:24 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 6:28 AM
Points: 1,258, Visits: 4,259

I'm a bit annoyed with myself...I've read the linked article before, but I went ahead and clicked the "Full backup" option simply because that's what I would do in that situation, regardless of what's possible! Should have read the possible answers more carefully before clicking.

Post #1322393

Mike Hays

Posted Thursday, June 28, 2012 6:43 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 7:02 AM
Points: 300, Visits: 307

Ouch!!! Got me!!! - Excellent question, learned something new.

Post #1322410

Dana Medley

Posted Thursday, June 28, 2012 6:55 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:11 AM
Points: 1,356, Visits: 874

I jumped the gun on this one and it seems I'm not alone in my actions. I just saw the first answer and was like "of course that's what you would do!" and then (X) incorrect. Sad

Excellent question Steve. I should have read all the available answers, but that first one just looked to tempting.

Oh no, we're toast! I've got this. *Keyboard clatter* Woah, how'd you do that? I'm a DBA...Booyah

Yeah, uh huh, you know what it is. Everything I do, I do it big

Post #1322421

rmechaber

Posted Thursday, June 28, 2012 7:23 AM

SSChasing Mays

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 7:43 AM
Points: 656, Visits: 2,921

Got it wrong for the best possible reason: I learned something.

Like many others, I thought a FULL backup was required to re-initiate the log chain, probably because that's what most recommendations say, following a switch of Full-to-Simple-to-Full recovery modes.

Here's an example from a SQL MVP (http://www.petri.co.il/sql-server-recovery-models.htm):

...if you’re in full mode and you want to truncate the log by switching to simple mode you’re free to do that. However, if you want to switch back to full mode and start taking log backups again, you’ll have to take a full backup before you can do that.

Great question, Steve!

Rich

Post #1322447

mohammed moinudheen

Posted Thursday, June 28, 2012 7:26 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 12:28 AM
Points: 2,170, Visits: 3,583

Good question, got this wrong though. Nice to have a myth busted.

Mohammed Moinudheen

Post #1322449

Luis Cazares

Posted Thursday, June 28, 2012 7:40 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 3:57 PM
Points: 960, Visits: 1,923

I was tempted with the first answer as it seemed correct. But a little bit of logic indicated me that there's no reason for the database backups to be incomplete so that it would be necessary to do a full backup. For the contrary, the log wouldn't be reliable after changing the recovery model from full to simple and back to full.

Nice question, I'm glad to have read all the answers before making a choice.

Luis C.
Please don't trust me, test the solutions I give you before using them.
Forum Etiquette: How to post data/code on a forum to get the best help

Post #1322461

cfradenburg

Posted Thursday, June 28, 2012 9:23 AM

SSCommitted

Group: General Forum Members
Last Login: Thursday, May 16, 2013 7:44 AM
Points: 1,555, Visits: 1,925

I actually just dealt with this in a slightly different way. We're doing a purge on a large DB and the app owner wanted a quick way to roll back and re-establish the log chain if anything went wrong. The decision was to take a snapshot, restore from that if there was an issue, and then do a diff. I actually wrote an article about it but haven't submitted it yet because it's still being reviewed by someone else before I send it in.

Post #1322553