In a perfect world, databases would be available 24 hours a day, 7 days a week, and 365 days a year. In the real world, this is not the case. That is why a good database administrator must be aware of what can and will go wrong with a database, including situations that are beyond your control. In this module you will learn some of the considerations a good DBA must evaluate when formulating or reassessing an existing backup and recovery plan.
By the end of this module you will be familiar with the following:
- DBA responsibilities
- Business considerations
- Operational considerations
- Technical considerations
- The components of a disaster recovery plan
- Importance of testing a backup and recovery strategy
There will come a time when your database crashes and your job is on the line. You cannot plan for every situation but the better prepared you are, the more likely you will be to survive the crisis. So, let us get started.
The next lesson examines the responsibilities of a database administrator.