Implementing Log Shipping

  • Peter A Carter


As discussed in  Chapter 11, log shipping is a technology you can use to implement disaster recovery and the scale out of read-only reporting. It works by taking the transaction log backups of a database, copying them to one or more secondary servers, and then restoring them, in order to keep the secondary server(s) synchronized. This chapter demonstrates how to implement log shipping for disaster recovery (DR). You also discover how to monitor and fail over log shipping.


Disaster Recovery Primary Server Secondary Server Primary Database Secondary Database 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Supplementary material (5 kb)
Chapter (zip 6 kb)

Copyright information

© Peter A Carter 2015

Authors and Affiliations

  • Peter A Carter
    • 1
  1. 1.BotleyUK

Personalised recommendations