Restore the encrypted database

Jun 01, 2020

We have to add the below script in the master database to restore an encrypted database.

 

CREATE MASTER KEY ENCRYPTION BY PASSWORD = '<your_password>'

CREATE CERTIFICATE <your_certificate_name> FROM File = '<path of.cer file>'

WITH PRIVATE KEY (FILE = 'path of .pvk file',

DECRYPTION BY PASSWORD = '<your_password>');

 

Now you have to do follow the normal restore process in SQL.

TAGS Backup SQL
Nirav Desai

About the Author

Nirav Desai

I am having 6+ experience in both .net and SQL. I am currently working as a Team Leader at MagnusMinds IT Solution. I am having knowledge of .net c#, MVC, .net core, Restful API, and SQL as well. I am managing multiple projects with the help of my teammates.