| 437-991-3573 | Data Engineering Services
Resources Tools
Experts in Microsoft SQL Server on Windows, Linux, Containers | Clusters, Always On, FCI | Migrations, Cloud, Performance

Check TDE progress
by BF (Principal Consultant; Architecture; Engineering)

Check TDE progress:

SELECT DB_NAME(database_id) AS Database_Name, Encryption_State,
Encryption_State_Desc =
CASE encryption_state
WHEN '0' THEN 'No database encryption key present, no encryption'
WHEN '1' THEN 'Unencrypted'
WHEN '2' THEN 'Encryption in progress'
WHEN '3' THEN 'Encrypted'
WHEN '4' THEN 'Key change in progress'
WHEN '5' THEN 'Decryption in progress'
WHEN '6' THEN 'Protection change in progress (The certificate or asymmetric key that is encrypting the database encryption key is being changed.)'
ELSE 'No Status'
Percent_Complete, Encryptor_Thumbprint, Encryptor_Type FROM sys.dm_database_encryption_keys