SQL Server 2008

備份憑證到硬碟成為檔案。
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');