Summary

In this lesson, you learned about high availability and DR features in Azure SQL Database. High availability is built into Azure SQL Database and is managed by Microsoft, whereas DR can be achieved by configuring active geo-replication as and when required. You also learned about ADR, a new feature introduced with Azure SQL Database and SQL Server 2019, which provides instant database recovery, transaction rollbacks, and aggressive log truncation. Furthermore, you saw how zone-redundant configuration provides additional high availability by having a copy of the database in multiple availability zones within the same region. In the next lesson, you will learn how to monitor an Azure SQL database using the Azure portal, dynamic management views, and extended events to help improve the performance of the application.