Use cases for SQL Server on Azure VMs
This section will demonstrate ways to leverage Azure VMs running SQL Server in a hybrid scenario, for scalability, migration, and disaster recovery.
As we mentioned previously in this book, SQL Server 2019 runs on both Windows and Linux, with almost complete feature parity between the two operating systems. You will access SQL Server on Linux using the same set of tools, and many of the common tools for scalability, migration, and disaster recovery, including backup and restore, log shipping, consistency checks, transactional replication, and so on. Even availability groups can be leveraged in a hybrid environment using an asynchronous commit.
The following sections present three sample use cases for Azure VMs in a hybrid environment:
- As a backup-restore target
- As an availability group replica
- As a transactional replication subscriber
The important thing to remember here is that a technology or feature doesn't...