SQL code to check if the database has TDE encryption enabled. 

SELECT
    db.name,
    db.is_encrypted,
    dm.encryption_state,
    dm.percent_complete,
    dm.key_algorithm,
    dm.key_length
FROM
    sys.databases db
    LEFT OUTER JOIN sys.dm_database_encryption_keys dm
        ON db.database_id = dm.database_id;
Source
https://stackoverflow.com/questions/61513305/check-if-my-database-instance-on-sql-server-is-encrypted-by-tde

Categorized in:

SQL,

Last Update: November 26, 2024