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

Transaction Log Backups Question Expand / Collapse
Author
Message
Posted Thursday, April 17, 2014 12:36 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 12, 2014 4:03 PM
Points: 47, Visits: 146
I appreciate the information. It all makes perfect sense. The very first log backup to apply is the one IMMEDIATELY following full database backup. The chain is unaffected by full backups, however, the starting log backup that is restored is the one immediately following that backup used for restore.

I take it the only to know which log backup to apply is by looking at the date time that log back up was created.
Post #1562818
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse