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.
bake13 is correct, when using Asymmetric keys you must use an EKM like Azure Key Vault or another one that supports SQL Server. You can create an Asymmetric key in SQL Server, but if it is not managed in an EKM, it cannot be used to do Encrypted Backups.