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

Is BooksOnline wrong or am I just too dense (on Recovery Paths) Expand / Collapse
Posted Sunday, October 28, 2012 11:31 AM


Group: General Forum Members
Last Login: Wednesday, December 19, 2012 4:17 AM
Points: 10, Visits: 52
I was just reading BOL on Recovery Paths ( and they have an example which just doesn't make any sense to me. It's the example where t3 and t4 become obsolete

Imagine a valid transaction inside t3 which adds 'X' to 'table1' which is restored during the PiT restore. Now they do a log backup t5 after some work done and claim that t3 is now obsolete for future recovery.
If I start a recovery, using the full backup t1, followed by t2 + t5, where will value 'X' come from? It was stored inside t3 which is skipped according to their explanation.
Post #1378045
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse