Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

TDE encryption

0 views
Skip to first unread message

Pat.Rick

unread,
Jun 25, 2010, 4:13:49 PM6/25/10
to
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

0 new messages