Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

High availability best practice? Expand / Collapse
Posted Wednesday, December 12, 2012 12:54 AM


Group: General Forum Members
Last Login: Monday, September 19, 2016 10:29 AM
Points: 130, Visits: 203
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.

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

Add to briefcase ««12

Permissions Expand / Collapse