SQL-Server

Restore the encrypted database

Nirav Desai
By Nirav Desai
Jun 01, 2020
Restore the encrypted database

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 have 9+ experience in both .net and SQL. I am currently working as a Team Leader at MagnusMinds IT Solution. I have knowledge of .net c#, MVC, .net core, Restful API, and SQL as well. I am managing multiple projects with the help of my teammates. 

RECENT POSTS

CATEGORIES

TAGS CLOUD