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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
