Remember, I??™mnot talking about full disaster recovery planning.
There are two methods to dealing with disaster: mitigating the risk of it occurring or the
impact when it does occur and responding to the disaster. Backup and recovery is a function
of disaster response.
When setting up a backup plan, you need to ask yourself some procedural questions.
Where should I place the backup files? What naming convention should I use? Should I
use single files or backup devices? These are questions that you, as the DBA, must ultimately
answer. I discussed many of the issues surrounding these questions in Chapter 2,
and I provided my biased opinion on how you should do things. However, everyone??™s
environment is unique, and you??™ll ultimately have to decide how you should do things
for yourself.
Some questions have a technical impact. How often should I back up the database?
How much time can the system be down or impacted by running a backup? How much
data loss is acceptable? In the event of a restore, how much downtime is acceptable?
While the answers to these questions ultimately dictate the technical steps you??™ll need to
take and which backup/recovery features you??™ll need to employ, only the business owners
of the database application are qualified to answer them.
Pages:
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209