A log restore essentially replays all of
the transactions that occurred. A differential restore, on the other hand, simply replaces
data changes that have occurred since the last full backup. Even a relatively large differential
backup can restore in a reasonable amount of time. A file or filegroup restore can
also speed things along, in some cases, depending on the specific nature of the disaster.
If a disk-array failure holds a subset of data files, you can restore those files alone if
you??™ve backed them up separately.
The most important thing is to try to determine both what the best-case scenario
and the worst-case scenario would be and present them to the appropriate business unit.
Also, use the most conservative estimates you can, but base them on real tests.
Potential Data Loss
???It??™s all about availability.??? This mantra is in vogue these days, but if that were really the
case, you wouldn??™t need to ask how much data loss is acceptable. For a large online
retailer, which is worse? Losing 30 minutes??™ worth of data or being down for 30 minutes?
I would argue the former.
Pages:
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221