SQL Server Always On Series -Adding Transparent Data Encryption (TDE) Enabled User DB to Always On

[@VajrakarurVlogs]

I have 2 replicas existing databases how to adda TDE and also secondary replica already database available that database need delete and TDE enable?

[@neeleshpathri]

Can you please tell me how you gonna add to existing DB's or is it enough to add in one Server and it will automatically sync with other server or we need to do manually ??

[@jbswiki]

You will have to move the certificate. I have provided the step-by-step instructions in this video. Have a look!!!

[@SurendraKumarDamerla]

if we are not saved the password or backup later, how to retrieve the master key password?

[@jbswiki]

You cannot restore the backup.

[@SurendraKumarDamerla]

@@jbswiki Is there any possibility to get the master key password ?

[@jbswiki]

@@SurendraKumarDamerla Not really. That is a feature, if it can be retrieved, then anyone can do it and will defeat the very purpose of TDE. One option will be to remove TDE and reconfigure it if you have access to SQL Server as a SA.