dbTalk Databases Forums  

TDE encryption

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup


Discuss TDE encryption in the microsoft.public.sqlserver.setup forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Pat.Rick
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.