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

High availability best practice? Expand / Collapse
Author
Message
Posted Wednesday, December 12, 2012 12:54 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 7:26 AM
Points: 101, Visits: 109
No it doesn't break the log chain. A full backup contains only enough transaction log necessary to be able to restore that database to a transactionally consistent time - the time at which the data reading portion of the full backup completed.

Paul has explained this very clearly in his blog.

Read the gail link above.

Regards,
RamaSankar,
MCTS,MCITP Sql Server 2008.
Post #1395478
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse