Home Forums SQL Server 2014 Administration - SQL Server 2014 SQL AlwaysOn Availability Group - Secondary can not decrypt database master key (DMK) RE: SQL AlwaysOn Availability Group - Secondary can not decrypt database master key (DMK)

  • January 30, 2018 at 9:51 am

    #1977897

    Gamleur84 - Thursday, January 18, 2018 9:48 AM

    Hi Steve,

    You are right, I took a backup of the Service Master Key and restore it on the secondaries and it worked !

    Thank you

    Did it break access to existing data?