SQL Server 2008

鑰匙管理語法。
--Service Master Key
--備份Service Master Key
BACKUP SERVICE MASTER KEY TO FILE = 'path_to_file'
ENCRYPTION BY PASSWORD = 'password‘
--Database Master Key
--以不同的保護密碼，在建立一份Database Master Key
ALTER MASTER KEY ADD ENCRYPTION BY PASSWORD =
'SecondDBAP@ssword';
--刪掉另一份Database Master Key
ALTER MASTER KEY DROP ENCRYPTION BY PASSWORD =
'SecondDBAP@ssword';