quote:
With this strategy I could potentially loose 11 hours worth of data if a FULL backup becomes corrupt. Any suggestions on how I can overcome this? What if I perform X-Log backups every 15min? Can I use X-Log backups to brigde the gap between the LAST KNOW GOOD FULL backup and DIFF and the moment of Data loss?
That is exactly why you need transaction log backups. As long as you have transaction log backups, you will be able to recover your database up to the point of time your database failure. In your example.
1. Restore 12am FULL backup.
2. Restore last diff backup before 12PM FULL backup which is corrupt.
3. Restore transaction log backup from last diff backup untill the transaction log backups have bridged 12PM FULL backup.
4. Restore latest diff backup.
5. Restore the rest of transaction log backups.