One of the primary responsibilities of a database administrator is to secure the information contained in the user databases. This responsibility consists of several different tasks, including designing for fault tolerance, developing a data restoration strategy that anticipates disaster, and securing the data. Chapter 7 covered designing for fault tolerance. This chapter covers developing a data restoration strategy, which includes a backup and restore plan. Chapter 9 covers the mechanics of performing backups and restorations. Chapters 10 and 11 cover data security. This chapter prepares you to select the appropriate backup and restore strategy for your database environment. First, you need to understand the issues involved in preparing for disaster. Next, you will learn about the types of database backups that are available to you. Finally, you will learn about how the data restoration process works, and what restoration options are available given the types of database backups and the recovery model you use.
There are no prerequisites for completing the lessons in this chapter.