Elements and Performance Criteria
- Review database architecture to plan backup and recovery
- Determine backup methods appropriate to database requirements
- Evaluate range of backup and restoration methods based on organisational and security standards and on the assessment of likely or possible failure scenarios
- Complete full off-line backups according to organisational and security standards with minimal down time
- Complete online file backups as determined by organisational and security standards and with minimal down time
- Employ disk mirroring and redundant array of inexpensive disks (RAID) hard disk configurations to keep copies of files
- Arrange off-site copies of backup files
- Establish recovery points and disaster-recovery procedures
- Determine database recovery points based on the backup arrangements according to organisational guidelines
- Test the restore process to ensure that the database can be restored to a given recovery point, with minimal down time
- Complete the restoration of the database to the point of failure, without loss of committed transactions
- Create and deploy standby database