1

As the title says, we have an existing availability group with a few databases and we'd like to enable TDE. I know that to do so we want to make sure all the servers have a database master key and the same certificate on each of them, however my question is what would happen if a failover event were to trigger from the Availability Group while the database was still in the process of encrypting?

Would it safely fail over to the secondary server in the AG and continue encryption safely? Would it safely fail over but the encryption would not complete? Would there be errors caused with the failover due to the fact that it was still in the process of encrypting?

1 Answer 1

3

Update

My original answer to this question was assumption based after reading MS Docs, and as such, was incomplete.

However, now that I've fully tested this in my lab and can confirm the that there is no impact when failing over an Availability Group while either the initial encryption or decryption process is running.

Upon failover, the encryptions process resumes where it left off and continues to completion.

I performed this test on SQL Server 2019 using a 50GB database.

3
  • Interesting, I hadn't considered a failover transitioning it into a READ ONLY state but that does make sense. I don't have a test region, if you could that would be amazing!
    – Sean K.
    Feb 16 at 14:18
  • 1
    @SeanK. See update answer. The failover is successful, and encryption resumes where it left off on the new primary. Feb 21 at 21:18
  • Thank you so much Brendan!!
    – Sean K.
    Feb 21 at 21:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.