There are two fundamental ways to do this. You could configure a multi-node Always On Availability Group (AG), a feature of SQL Server itself, or you could use Windows Server Failover Clustering ...

We wrote broadly about those announcements here, but for this column, I wanted to cover some important features in greater detail. Always On ... group member nodes. In SQL Server 2019, Microsoft ...