This article discusses strategies for improving database recovery times after catastrophic failure for companies that use the “tried-and-true” backup and restore approach for data recovery. This method focuses on reducing the amount of data that needs to be backed up, stored, and subsequently retrieved for restoring transactional mission-critical databases to a current, consistent, and complete state in order to continue processing. It also focuses on the so-called online backup problem (where the database is open for processing while the backup occurs), and uses several techniques to reduce the amount of data that must be stored while the backup is taking place as well as for the subsequent changes to the data after the backup completes. Since there is a growing need for an economic and efficient way to back up very large-scale databases, many companies are returning to physical tape to fill this need. The better backup method significantly and efficiently uses backup media and backup/restore processing to improve current techniques.
The Better Backup Method