在SQL Server 中启用透明数据加密(TDE)。 使用非对称加密密钥保护 SQL Server 数据库的备份。 将非对称加密密钥存储在 SQL Server 可扩展密钥管理(EKM)提供程序中。 还原SQL Server 数据库的备份。 在这种情况下,可能需要很长时间才能完成还原,因为与 EKM 提供程序之间存在不必要的通信。
TDEThumbprintvarbinary(32)NULL顯示資料庫加密金鑰的指模。 加密程式指模是用來加密金鑰的憑證 SHA-1 雜湊。 如需資料庫加密的詳細資訊,請參閱透明資料加密 (TDE)。 SnapshotURLnvarchar(360)NULL適用於:SQL Server (SQL Server 2016 (13.x) (CU1) 到目前的版本。
Error after you perform TDE certificate or key rotation Error when backing up in-memory database Error when you create a snapshot Error 33111 when restoring backups that use SQL Server Connector for Key Vault Restore or recovery may fail Schedule and automate Backups of databases Troubleshoot ba...
Error after you perform TDE certificate or key rotation Error when backing up in-memory database Error when you create a snapshot Error 33111 when restoring backups that use SQL Server Connector for Key Vault Restore or recovery may fail ...
The encryptor thumbprint is a SHA-1 hash of the certificate with which the key is encrypted. For information about database encryption, see Transparent Data Encryption (TDE). SnapshotURL nvarchar(360) NULL Applies to: SQL Server (SQL Server 2016 (13.x) (CU1) through current version. The ...
TDEThumbprintvarbinary(32)NULLShows the thumbprint of the Database Encryption Key. The encryptor thumbprint is a SHA-1 hash of the certificate with which the key is encrypted. For information about database encryption, seeTransparent Data Encryption (TDE). ...
Transact-SQL (T-SQL) 参考资料 日期和时间 hierarchyid 方法(数据库引擎) 数字 String 和 binary 空间地理和实例(地理数据类型) 空间几何和实例(几何数据类型) 数据类型 XML DBCC 函数 语言元素 查询 语句 语句 常规 修改 备份和还原 BACKUP BACKUP CERTIFICATE ...
Back up the TDE certificate using the AWS KMS key to an Amazon Simple Storage Service (Amazon S3) bucket. Back up the RDS for SQL Server database to the S3 bucket. Extract the ciphertext-blob from the S3 metadata of the private key file. Share the AWS...
Back up the TDE certificate using the AWS KMS key to an Amazon Simple Storage Service (Amazon S3) bucket. Back up the RDS for SQL Server database to the S3 bucket. Extract the ciphertext-blob from the S3 metadata of the private key file. Share the AWS...
CertificateCollection CertificateEvents CertificateSourceType ChangeTracking 檢查 CheckCollection ClusterMemberState ClusterMemberType ClusterQuorumState ClusterQuorumType CollationInfo CollationVersion CollectionNotAvailableException 資料行 ColumnCollection ColumnEncryptionKey ColumnEncryptionKeyCollection ColumnEncryptionKeyValue...