I??™ll cover these situations, but I??™ll focus more on how
the technology helps minimize the likelihood or impact of any given disaster scenario.
The first stop is log shipping.
Environmental disasters are the least likely to occur, but they tend to be the most
difficult to recover from, much less prepare for. In many ways, log shipping is the ultimate
in environmental disaster mitigation. It??™s cost-effective, relatively easy to use,
and stable.
The practice of log shipping is used to keep a warmstandby server available in case
the primary server fails. The method is literally to copy log backups from the primary
server to the secondary server where you then restore them. In addition to serving as
warmbackups, these standby databases can also be accessed by clients as read-only
databases if necessary.
Some people find log shipping to be archaic, unsafe, or require too much manual
intervention, making it an unviable mitigation approach. I fundamentally disagree. Yes,
there is a manual aspect to the process. Yes, there is a guarantee of a certain amount of
data loss. And yes, log shipping in one form or another has existed for more than a
decade.
Pages:
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284