Trn log backup chain

Question

Trn log backup chain

Barcelona10

SSCertifiable

Points: 5372
More actions
March 27, 2014 at 2:50 pm

#289830

Hi all
I have setup maintenance plan which does 2 full(12AM and 5AM) backups and trn log backup starting 5am(every 5 min) and ends 10PM.If i take extra full backup at 11am would that brake trn log chain?.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004425 More actions · Answer 1

Barcelona10 (3/27/2014)
Hi all
I have setup maintenance plan which does 2 full(12AM and 5AM) backups and trn log backup starting 5am(every 5 min) and ends 10PM.If i take extra full backup at 11am would that brake trn log chain?.

Full backups don't break the log chain.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

CKX SSCrazy Points: 2519 More actions · Answer 2

This post goes into a bit more detail:

http://sqlinthewild.co.za/index.php/2011/03/08/full-backups-the-log-chain-and-the-copy_only-option/

Barcelona10 SSCertifiable Points: 5372 More actions · Answer 3

thank you for replay.How about differential backup chain?.

Jeff Moden SSC Guru Points: 1004425 More actions · Answer 4

Barcelona10 (3/28/2014)
thank you for replay.How about differential backup chain?.

Read the article at the link provided in the previous post. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)