Forum Discussion
Solved
Encrypted backups using Asymmetric key
Hello, I am creating asymmetric keys at the master level and at the database level. Asymmetric keys are showing in the security option, but when I am trying to take encrypted backup using asymmetr...
Hi Ayushtz --
Apologies, I missed that you had already performed the encryption using certificates. At any rate, I didn't see it mentioned, but did you implement an EKM? Using an asymmetric key to perform backup encryption is only supported when an EKM is configured for SQL Server. SQL Server does not provide EKM capabilities. Take care.
I have already done the task with certificates, now I am using asymmetric keys to create an encrypted backup but the keys are not visible in the "asymmetric key" option.
This doc is only for certificates.
This doc is only for certificates.
bake13
Microsoft
MicrosoftHi Ayushtz --
Apologies, I missed that you had already performed the encryption using certificates. At any rate, I didn't see it mentioned, but did you implement an EKM? Using an asymmetric key to perform backup encryption is only supported when an EKM is configured for SQL Server. SQL Server does not provide EKM capabilities. Take care.