Check/Verify SQL DB is encrypted , TDE

Select DB_NAME(database_id),*
From sys.dm_database_encryption_keys
where encryption_state = 3
go

Advertisements