備份憑證到硬碟成為檔案。
BACKUP CERTIFICATE NorthwindCert
TO FILE = 'C:\MyServerCert'
WITH PRIVATE KEY (FILE = 'C:\MyServerCertKey',
ENCRYPTION BY PASSWORD = 'password');
--還原先前的憑證
CREATE CERTIFICATE MyServerSert
FROM FILE = 'C:\MyServerCert'
WITH PRIVATE KEY (FILE = 'C:\MyServerCertKey',
DECRYPTION BY PASSWORD = 'password');

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 flyfox 的頭像
    flyfox

    flyfox

    flyfox 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄