• Article

Manage Database Encryption (Properties Page)

Transparent Data Encryption (TDE) in SQL Server 2008 provides automatic database encryption. For more information, see Understanding Transparent Data Encryption (TDE).

Use this page to view or modify the options for encryption on the selected database.

Property

Value

ModifyDate

Shows the date and time when the database encryption key was modified.

Keylength

Displays the length of the database encryption key.

RegeneratedDate

Shows the date and time when the database encryption key was regenerated.

CreateDate

Shows the date and time when the database encryption key was created.

DatabaseEncryptorType

The type of encryptor used to encrypt the database.

Encryptor

Displays the name of the certificate that was used to encrypt the database.

SetDate

Shows the last date and time when the database encryption key was set.

DatabaseEncryptionAlgorithm

Displays the algorithm the database encryption is currently using.

EncryptionState

Displays the current encryption status of the database.

OpenedDate

Shows the date and time when the database encryption key was last opened.