Backup and Recovery

Backup and recovery is one of the most complicated areas of database management. Having the right resources to do a recovery is critical, and unfortunately in many cases, not addressed until after data is already lost.

Database backup and recovery comes in many flavors, from recovering from a dropped object to bouncing back from a major disaster, and everything in between. Recoveries done manually can be error prone, time consuming and resource intensive. Database Administrators can be faced with many challenges for example:

• Can a transaction be reversed or does the entire database have to be recovered?
• How can you determine which objects have been impacted?
• Do you have the necessary resources to recover to a point in time?
• Are you prepared for a disaster? Can you recover your subsystem? How much data are you willing to lose?