Abstract
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.
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
Electronic Supplementary Material
Below is the link to the electronic supplementary material.
Rights and permissions
Copyright information
© 2015 Peter A Carter
About this chapter
Cite this chapter
Carter, P.A. (2015). Implementing Log Shipping. In: Pro SQL Server Administration. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-0710-9_14
Download citation
DOI: https://doi.org/10.1007/978-1-4842-0710-9_14
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-0711-6
Online ISBN: 978-1-4842-0710-9
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books