Summary

In this lesson, we have learned about high availability and disaster recovery concepts, as well as the terminology and the different solutions available in SQL Server to achieve HA and DR. We have discussed the importance of RTO and RPO and the role they play in selecting an HA and DR strategy or solution.

We have also learned about replication concepts and terminology, and different types of replications that are available in SQL Server. We looked at how to configure and troubleshoot snapshot replication.

In the next lesson, we'll learn about transactional replication.