Chapter 32. Log shipping
After completing this chapter, you will be able to
Understand when and why to use log shipping.
Understand the components that play a role in log shipping.
Configure log shipping.
Log shipping is a low-cost, straightforward, and resilient solution you can use to achieve high availability and/or to offload reporting. It is used to automatically synchronize two databases at a chosen time interval. It accomplishes this by backing up, copying, and restoring transaction logs on a scheduled basis. With log shipping, failover is a manual process and is not automated. This is a primary drawback to log shipping when compared to a more robust technology such as AlwaysOn Availability Groups. The secondary database can be made available ...
Get Microsoft® SQL Server® 2012 Step by Step 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.
