GilaMonster (3/14/2008)
GSquared (3/13/2008)
In that case, you'd be recovering from the prior day's full backup, and the most recent log backup.To do that, you'll need the previous day's full DB backup, and all the transaction log backups, in order, since that backup. Since the log backup right after the failing full is WITH INIT, the log backup chain is broken at that point.
That was the point of my original reply on this. Of course, that's assuming the transaction log is being truncated by the backups. If not, then each transaction log backup is complete and could be used (I think). I've never done anything as odd as what's being proposed here, so I've never had reason to test it.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon