Forum Discussion

Copper Contributor

Nov 08, 2021

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...

sql server

bake13
Nov 15, 2021
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.

Backup Encryption - SQL Server | Microsoft Docs

bake13

Microsoft

Nov 09, 2021

Hi Ayushtz -- Did you follow the steps outlined in the document linked below? Take care.

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/create-an-encrypted-backup?view=sql-server-ver15

Ayushtz

Copper Contributor

Nov 15, 2021

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.

bake13
Microsoft
Nov 15, 2021
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.

Backup Encryption - SQL Server | Microsoft Docs