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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability