I have a PUB on a SQL 2014 Ent server where the database is encrypted w/ TDE (Key algorithm=AES, Key Length=128)
I have a SUB to that PUB residing on a SQL 2017 Ent server.
When I check the PUB DB, it is encrypted. When I check the SUB DB is is NOT encrypted. I use this SQL to check:
db.name, db.is_encrypted, dm.encryption_state, dm.percent_complete, dm.key_algorithm, dm.key_length
sys.databases db LEFT OUTER JOIN sys.dm_database_encryption_keys dm ON db.database_id = dm.database_id
WHERE is_encrypted > 0 ORDER BY name;
Is there a setting I can use to get the SUBSCRIBING DB to be encrypted?