I am reading this summary from the book 'Pro SQL Server 2019 Administration' from Carter:
And it specifies:
hot → automatic failover → used for high availability (HA)
warm → manual failover → used for disaster recovery (DR)
Since 'high availability' is usually planned and 'disaster recovery' is not, shouldn't we aim for manual failover in 'high availability' scenarios?
What's the point of having automatic failover for high availability?
It makes sense to me that if DR occurs, failover should be automatic, and if we have something planned (patching, etc.) and we have HA, we can do the failover manually...