A production database has the following daily midnight backup schedule which includes all table spaces. The database incurs the same volume of daily activity
(inserts, updates, and deletes).
Sunday Delta -
Monday Incremental -
Tuesday Delta -
Wednesday Delta -
Thursday Incremental -
Friday Delta -
Saturday Full -
Which day would you expect a RECOVER DATABASE following that days backup to take the longest time to complete?
Recovering from a Delta backup requires restoring from the most recent full or incremental backup plus the delta backups since then. On Wednesday, recovery would involve restoring the Saturday full backup, the Monday incremental backup, and the delta backups from Tuesday and Wednesday. This makes Wednesday the day with the longest recovery time due to the cumulative restoration process from multiple preceding backups.
Yes i feel D is correct
The correct answer is D. restore following image. Fullbackup + Incremental (Mon) + delta (Tue)+delta(Wed)
The answer A is correct. An incremental backup image is a copy of all database data that changed since the most recent successful, full backup operation. A delta backup image is a copy of all database data that changed since the most recent successful backup operation of any type. In our example, you have to restore thursday's incremental backup (5 days) then restore the friday's delta backup.