The location, recovery mode, and backup technique all
play different roles in addressing individual disaster categories.
Each backup option has its own benefits and drawbacks, but you need to at least
have one single full backup. Log backups are critical for point-in-time recovery, and differential
backups can speed the restore process significantly. Having explored the process
of backup, I??™ll now show you how you can restore these backups should disaster strike.
CHAPTER 2 n MAKING DATABASE BACKUPS 41
Restoring a Database
Performing a backup is not only a relatively simple task, but it??™s also a relatively safe task.
Rarely as a DBA do you fret over whether performing a backup will have negative consequences
on your database. Restoration, on the other hand, is a completely different
matter. It isn??™t a routine task, so unless you have a very unstable environment and get
practice on a regular basis, restoration can tend to feel unfamiliar. Combine that general
uneasiness with a complicated process, the likelihood of an executive looking over your
shoulder, impatient users wanting the system back, and the knowledge that an incorrect
choice in restore options could be detrimental, and the result is stress.
Pages:
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120