December 15, 2021 at 6:55 pm
I have one DB in of my dev server which should be encrypted like any other DBs on that server. So when I run this command, I see the status 'ENCRYPTED"
SELECT DB_NAME(database_id) AS DatabaseName, encryption_state,
encryption_state_desc =
CASE encryption_state
WHEN '0' THEN 'No database encryption key present, no encryption'
WHEN '1' THEN 'Unencrypted'
WHEN '2' THEN 'Encryption in progress'
WHEN '3' THEN 'Encrypted'
WHEN '4' THEN 'Key change in progress'
WHEN '5' THEN 'Decryption in progress'
WHEN '6' THEN 'Protection change in progress (The certificate or asymmetric key that is encrypting the database encryption key is being changed.)'
ELSE 'No Status'
END,
percent_complete,encryptor_thumbprint, encryptor_type FROM sys.dm_database_encryption_keys
where DB_NAME(database_id) = 'DBName'
GO
But when I query sys.databases, the is_encrypted column shows 0. What am I missing?
select distinct name, is_encrypted from sys.databases
where database_id > 4
and is_encrypted = 0
December 16, 2021 at 7:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
December 28, 2021 at 8:46 am
This was removed by the editor as SPAM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply