While creating a backup or using the back up of an encrypted database, you may encounter the error - “Please create a master key in the database or open a master key in the session before performing this operation”
You can resolve this error by using:
OPEN MASTER KEY DECRYPTION BY PASSWORD = ‘thepassword'
ALTER MASTER KEY ADD ENCRYPTION BY SERVICE MASTER KEY
Did you like this post?
|subscribe via rss||subscribe via e-mail|
|print this post||follow me on twitter|