Differential backup question (Full restore followed by ONLY one differential restore ?)

HI,
Suppose this Backup Plan
Full DB backup on Sunday 23:00
Backup-log on monday 09:00
Backup-log on monday 12:00
Backup-log on monday 15:00
Differential backup on monday 22:00
Full DB backup on monday 23:00
Backup-log on tuesday 09:00
Backup-log on tuesday 12:00
Backup-log on tuesday 15:00
Differential backup on tuesday 22:00
Full DB backup on tuesday 23:00
Backup-log on wednesday 09:00
Backup-log on wednesday 12:00
Backup-log on wednesday 15:00
Is it possible to restore 2 consecutives Differential backups like this ?
Restore Full from Sunday 23:00 (suppose Full bkps on
monday and tuesday are damaged)
Restore Differential from monday 22:00
Restore Differential from tuesday 22:00
Restore transaction-log from wednesday 09:00
Restore transaction-log from wednesday 12:00
Restore transaction-log from wednesday 15:00
Thank you
Danny (I plan to create differential bkp because of existing non-logged
operations)A differential backup contains changes after the last database backup. In your case
you will need full backup of monday. If you have it then sequence would be:
Full DB backup on monday 23:00
Differential backup on tuesday 22:00
Restore transaction-log from wednesday 09:00
Restore transaction-log from wednesday 12:00
Restore transaction-log from wednesday 15:00
--
- Vishal