while setting up
AlwaysOn - Availability Group on a test system,
I generated all the restores from live and restored them to this new server.
then I backup all these databases to a network share to make them ready for being added to the
when then adding then to the
availability group I get this message below, for a couple of them. (2 or 3 databases out of 50)
I don't have the master key for that live server - the server where the databases come from.
I have a backup of the master key in the original live server.
I also have backups of certificates:
Not so good news:
I haven't got the decryption password for that master key backup file
This question seems to be related:
What do I need to restore an encrypted MSSQL database?
How can I restore those databases only having a backup of the master key in the original server?
P.S. I don't have the decryption password for that master key backup file - above pic
Maybe I will have to regenerate the master key.
extrasensitive data, it would be great if I could get rid of that link to the