Microsoft Log Shipping Overview

Another, more direct method of creating a completely redundant database image is to use log shipping. Microsoft certifies log shipping as a method of creating an “almost” hot spare. Some folks even use log shipping as an alternative to data replication. Log shipping used to be referred to as “poor man's replication” when replication was an add-on product. Now that they are both included in the box, neither one is really any more expensive to implement than the other. Actually, replication can be cheaper to implement, as it is available in the Standard Edition, while log shipping officially is only available in the Enterprise Edition. Log shipping is comprised of three primary functions:

  • Makes an exact image copy ...

Get Microsoft® SQL Server High Availability now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.