2021. 4. 26. 09:26
SQL SERVER
ALTER DATABASE [DB명] SET ENCRYPTION OFF;
GO
use DB명
DROP DATABASE ENCRYPTION KEY
-- 4. 암호화 상태 확인
SELECT DB_NAME(e.database_id) AS DatabaseName,
e.database_id,
e.encryption_state,
CASE e.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'
END AS encryption_state_desc,
c.name,
e.percent_complete
FROM sys.dm_database_encryption_keys AS e
LEFT JOIN master.sys.certificates AS c
ON e.encryptor_thumbprint = c.thumbprint
'SQL SERVER' 카테고리의 다른 글
linked server Disable하기 (0) | 2021.10.21 |
---|---|
IT/DBORACLE에서 MSSQL 마이그레이션 시 참고사항 (0) | 2021.05.25 |
DB별 여러가지통계정보(CPU, I/O, Duration 등) (0) | 2021.04.22 |
msdb 의 sysmaintplan_logdetail 크기(Size)로 인한 문제가 될 경우 (0) | 2021.04.06 |
sql server Lock정보 확인 (0) | 2020.12.09 |