Approaches to Database Recovery

Recover from Journals
Restore from Backup
Repair with DSE
Preventive Maintenance

If you experience database integrity problems, there are three strategies to consider when approaching the recovery:

To achieve the intended result, correction of database errors requires careful planning. Each strategy differs from the others in the scope of damage it can handle, in skills needed, and in database availability.