The first goal of log shipping
is to get that data onto another server. Granted, the failover process isn??™t instantaneous,
and data loss is essentially guaranteed. It has its drawbacks, but log shipping
is an excellent solution to mitigating environmental disasters.
??? Hardware: The same holds true for hardware errors. Again, you??™ll lose some data,
but at least you??™ll know exactly how much data is lost.
??? Media: This is the dangerous category, not because of data loss or downtime, but
because of the failover process itself. A media disaster may turn out to have a
straightforward and relatively quick resolution. Jumping to invoke a secondary
server during a media disaster could be a mistake, resulting in more time and data
loss than simply waiting to repair the primary server.
CHAPTER 6 n MAINTAINING A WARM STANDBY SERVER VIA LOG SHIPPING 171
??? Process: There is a real danger in relying on log shipping to mitigate process errors.
It can be effective, if and only if the error is detected before the shipped log backup
has been restored. In a configuration where the log-shipping interval is quite frequent,
it is unlikely this will be the case.
Pages:
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336