Summary

In this lesson, we talked about log shipping, its pros and cons, and how to configure it as a DR solution. We learned that sqllogship.exe, an independent executable, is responsible for carrying out the log shipping tasks, performing transaction log backups, copying the log backup to the shared folder, and restoring the transaction log backup to the secondary server.

Each of the log ship tasks are scheduled using a SQL Server agent jobs. Log shipping is one of the old DR solutions which can also be used when migrating from one SQL Server instance to another.

This brings us to the end of this book. You can visit https://azure.microsoft.com/en-in/solutions/architecture/ to explore the different application architectures and better understand how HA and DR work with different kinds of applications.