None of these arguments specifically demonstrates that it isn??™t an effective tool
when it comes to disaster mitigation. It may not be as ???sexy??? as some of the newer technologies,
but log shipping still gets the job done.
In this chapter, I??™ll explore log shipping in general and show you how to automate it
with SQL Server 2005. In addition to configuration, I??™ll discuss the actions required during
a failure and explain how to reset the entire configuration back to its original state
(which isn??™t always a straightforward task).
141
C H A P T E R 6
Log Shipping vs. Replication
While talking with colleagues or giving presentations on disaster recovery, the subject
of replication in the context of establishing a standby server inevitably comes up. Many
believe that replication instead of log shipping should be used for establishing a
standby server. Since I don??™t have a chapter in this book called ???Replication,??? I obviously
don??™t agree.
There is a legitimate argument here, though. I concede the following points about
using replication to create a standby server:
??? Faster data transfer: In general, the process of getting data from point A to point B
is faster when you use replication, because it is direct communication.
Pages:
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285