Groups > comp.databases.ms-sqlserver > #571

Re: SQL Server Database encryption_state still says 2 for a 110GB Database for the past one week

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver, microsoft.public.sqlserver.programming
Subject	Re: SQL Server Database encryption_state still says 2 for a 110GB Database for the past one week
Followup-To	comp.databases.ms-sqlserver
Date	2011-07-26 14:38 +0200
Organization	Erland Sommarskog
Message-ID	<Xns9F2E94E1C40C3Yazorman@127.0.0.1> (permalink)
References	<9c759c9d-2b86-4058-b91f-5f438e6d70fd@hd10g2000vbb.googlegroups.com>

Cross-posted to 2 groups.

Followups directed to: comp.databases.ms-sqlserver

Show all headers | View raw

Query Builder (querybuilder@gmail.com) writes:
> I implemented TDE on one of my SQL Server instance. When I query the
> database state with the following query it returns 2 to one of my
> databases which is about 110GB. Its been 2 weeks and its still says
> 2.
> 
> SELECT db_name(database_id), encryption_state,*
> FROM sys.dm_database_encryption_keys
>... 
> I would greatly appreciate if anyone can shred some light on this and
> confirm that the encryption is complete. How do I confirm that the
> encryption is complete?

Well, if it says 2, that would indicate that it is not complete. What does 
the other columns in this DMV report for this database? Particularly, what 
does percent_complete report?

I found 
http://www.simple-talk.com/sql/database-administration/transparent-data-
encryption/
which suggests some alternate ways to verify completion.

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

SQL Server Database encryption_state still says 2 for a 110GB Database for the past one week Query Builder <querybuilder@gmail.com> - 2011-07-25 20:39 -0700
  Re: SQL Server Database encryption_state still says 2 for a 110GB Database for the past one week Erland Sommarskog <esquel@sommarskog.se> - 2011-07-26 14:38 +0200
    Re: SQL Server Database encryption_state still says 2 for a 110GB Database for the past one week Query Builder <querybuilder@gmail.com> - 2011-07-28 06:26 -0700
      Re: SQL Server Database encryption_state still says 2 for a 110GB Database for the past one week Erland Sommarskog <esquel@sommarskog.se> - 2011-07-28 23:11 +0200
        Re: SQL Server Database encryption_state still says 2 for a 110GB Database for the past one week Query Builder <querybuilder@gmail.com> - 2011-07-29 12:41 -0700
          Re: SQL Server Database encryption_state still says 2 for a 110GB Database for the past one week Erland Sommarskog <esquel@sommarskog.se> - 2011-07-30 00:09 +0200

csiph-web