若要使用或不使用私钥还原备份证书,请使用 CREATE CERTIFICATE 语句。若要将私钥还原到数据库中的现有证书,请使用 ALTER CERTIFICATE 语句。在你执行备份后,这些文件就会通过 ACL 备份到 SQL Server 实例的服务帐户。 如果需要将证书还原到在不同帐户下运行的服务器,需要将文件权限调整为文件可供新帐户读取。
syntaxsql Copy -- Syntax for SQL Server BACKUP CERTIFICATE certname TO FILE = 'path_to_file' [ WITH [FORMAT = 'PFX',] PRIVATE KEY ( FILE = 'path_to_private_key_file' , ENCRYPTION BY PASSWORD = 'encryption_password' [ , DECRYPTION BY PASSWORD = 'decryption_password' ] ) ] synta...
BACKUP CERTIFICATE sales05 TO FILE = 'c:\storedcerts\sales05cert'; GO B. 导出证书和私钥 在以下示例中,已备份的证书的私钥将使用密码997jkhUbhk$w4ez0876hKHJH5gh进行加密。 复制代码 BACKUP CERTIFICATE sales05 TO FILE = 'c:\storedcerts\sales05cert' WITH PRIVATE KEY ( FILE = 'c:\storedkeys\...
BACKUP CERTIFICATE sales05 TO FILE = 'c:\storedcerts\sales05cert'; GO 1. 2. 3. B. 导出证书和私钥 在以下示例中,已备份的证书的私钥将使用密码997jkhUbhk$w4ez0876hKHJH5gh进行加密。 复制代码 BACKUP CERTIFICATE sales05 TO FILE = 'c:\storedcerts\sales05cert' WITH PRIVATE KEY ( FILE = 'c...
When performing a backup, the files will be ACLd to the service account of the SQL Server instance. If you need to restore the certificate to a server running under a different account, you'll need to adjust the permissions on the files so that they're able to be read by the new acco...
SERVER ASYMMETRIC KEY = Encryptor_Name The SERVER CERTIFICATE and SERVER ASYMMETRIC KEY are a certificate and an asymmetric key created in master database. For more information, see CREATE CERTIFICATE and CREATE ASYMMETRIC KEY respectively. Warning When encryption is used in conjunction with the FILE...
{ AES_128 | AES_192 | AES_256 | TRIPLE_DES_3KEY } , encryptor_options ) <encryptor_options> ::= SERVER CERTIFICATE = Encryptor_Name | SERVER ASYMMETRIC KEY = Encryptor_Name <log_specific_options> [ ,...n ]::= --Log-specific Options { NORECOVERY | STANDBY = undo_file_name } |...
SERVER CERTIFICATE = Encryptor_Name SERVER ASYMMETRIC KEY = Encryptor_Name SERVER CERTIFICATE 和SERVER ASYMMETRIC KEY 是在master 数据库中创建的证书和非对称密钥。 有关详细信息,请分别参阅 CREATE CERTIFICATE 和CREATE ASYMMETRIC KEY。 警告 将加密与 FILE_SNAPSHOT 参数一起使用时,使用指定的加密算法对元数据...
SERVER ASYMMETRIC KEY = Encryptor_Name The SERVER CERTIFICATE and SERVER ASYMMETRIC KEY are a certificate and an asymmetric key created in master database. For more information, see CREATE CERTIFICATE and CREATE ASYMMETRIC KEY respectively. Warning When encryption is used in conjunction with the FILE...
SERVER CERTIFICATE 與SERVER ASYMMETRIC KEY 是在資料庫 master 中建立的憑證與非對稱金鑰。 如需詳細資訊,請各別參閱 CREATE CERTIFICATE 及CREATE ASYMMETRIC KEY。 警告 搭配FILE_SNAPSHOT 引數使用加密時,中繼資料檔案本身會使用指定的加密演算法進行加密,而系統會確認已針對資料庫完成透明資料加密 (TDE)。 對於資...