Abstract
As discussed in Chapter 13, 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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2019 Peter A. Carter
About this chapter
Cite this chapter
Carter, P.A. (2019). Implementing Log Shipping. In: Pro SQL Server 2019 Administration. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5089-1_15
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5089-1_15
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-5088-4
Online ISBN: 978-1-4842-5089-1
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books