Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

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

Show all headers | View raw

I really appreciate your response...

The percent_complete says 0 for all the databases including the one
which is still encrypting..
is_encrypted = 1 for all Databases
encryption_state = 2 for only this DB but everything else is 3.

The mirroring to DR is also synchronized. I do see the backup size has
grown to be about 81GB where it used to be about 25GB with
compression. (The db size is actually 115GB).

I am worried as its been almost 2 weeks. Any help would be much
appreciated..

Thanks again..

Regards,
BK.




On Jul 26, 8:38 am, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Query Builder (querybuil...@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 foundhttp://www.simple-talk.com/sql/database-administration/transparent-data-
> encryption/
> which suggests some alternate ways to verify completion.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@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