Share via

Lost Encryption password

Samy Ponnusamy 0 Reputation points
2025-03-24T14:57:47.1633333+00:00

Someone from our company had previously setup an automated backup for SQL server VM with encryption enabled however, we don't have the password they set it up. Without the password setup originally, we are not able to restore any backups. How do we fix this issue.

SQL Server Database Engine
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Azar 31,720 Reputation points MVP Volunteer Moderator
    2025-03-24T20:45:41.4466667+00:00

    Hi there' Samy Ponnusamy

    Thanks for using QandA plaftorm

    Unfortunately, without the original encryption password, restoring the backups is not possible, as SQL Server TDE and Backup Encryption require the correct key to decrypt the data.

    First, check if the key is stored in Azure Key Vault or a company password manager. If certificate-based encryption was used, look for a backup of the certificate and private key. If no key is found, Microsoft Support may help, but recovery is unlikely. Going forward, store encryption keys securely in Azure Key Vault to prevent this issue.

    Link to raise support

    https://portal.azure.com/#view/Microsoft_Azure_Support/HelpAndSupportBlade/~/overview

    If this helps kindly accept the answer thanks much.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.