Quote:
A table with with more than 10 lacs record has been dropped unknowingly.
You just learned the hard way the reason why we do backups.
Quote:
And we maintain incremental backup so no luck we found because it happened 5 days back.
A backup which can't recover things the are more than 5 days old
is not a good backup and may be not called a backup at all.
Incremental backup is a technique used to reduce the size of daily backup, but it can't be used alone. Usually, it is associated with regular full backups (weekly or monthly).
When planning a backup, you have to answer a few questions:
- What can't I afford to loose ?
- For how many days should I be able to recover data ?
- How long to recover the data from a backup ?
from the answers to these questions, you deduce how to organize the backups.
And whe, you plan the backup, always ask yourself "What append in worst case ?"