Page History: Restoring an Encrypted Database - SQL Server

Compare Page Revisions

0 Current 0

« Older Revision - Back to Page History - Current Revision

Page Revision: Fri, May 02, 2014, 9:44 AM

Overview¶

This article explains the extra steps you need to take when restoring an encrypted database. You MUST have the password for the master key in order to do this.

Procedure¶

Substituting the password for your master key, run the following script.

OPEN MASTER KEY DECRYPTION BY PASSWORD = 'MyPassword'
go
ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY
go
close master key
go