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'
END,
Percent_Complete, Encryptor_Thumbprint, Encryptor_Type FROM sys.dm_database_encryption_keys
|
|
|
|
|
|