Encrypt an existing MS SQL Server 2019 database in Always on environment using TDE.

Transparent Data Encryption (TDE) 

Transparent Data Encryption (TDE) in SQL Server protects data at rest by encrypting database data and log files on disk. It works transparently with existing applications, so they don’t need to be changed when TDE is enabled. TDE uses real-time encryption at the page level. In SQL Server 2019, TDE is available as a Standard Edition feature, eliminating the need to upgrade to Enterprise Edition just for TDE.

Restore a database in the MS SQL Server Always On Availability Group

Prerequisites

1.     Backup File: Ensure you have a valid full backup of the database you want to restore. I used AdventureWorks2019.bak for my test.