TDE encryption -
06-25-2010
, 03:13 PM
Hi Friends,
SQL 2008 - TDE encryption
I'm trying to apply TDE for one of my databases, all seems run fine,
except that when I run
SELECT db_name(database_id), encryption_state
FROM sys.dm_database_encryption_keys with (nolock)
after applying encryption to database, the state of encryption is 2
(Encryption in progress).
is this expected ? or it should be 3 (Encrypted) ?
Thanks in advance,
Pat |