question

ToddAi-1692 avatar image
0 Votes"
ToddAi-1692 asked princerastogi commented

Failed to add a database to failover group

We are always get this error when try to add a database to a failover group. Is there any possible reason for this error? thanks
"statusMessage": "{\"status\":\"Failed\",\"error\":{\"code\":\"ResourceOperationFailure\",\"message\":\"The resource operation completed with terminal provisioning state 'Failed'.\",\"details\":[{\"code\":\"FailoverGroupCreateOrUpdatePartiallySucceeded\",\"message\":\"Create or update Failover Group operation successfully completed; however, some of the databases could not be added to or removed from Failover Group.\"}]}}"

azure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

NavtejSaini-MSFT avatar image
0 Votes"
NavtejSaini-MSFT answered princerastogi commented

@ToddAi-1692

We checked the error in our database and found several reasons for the error.

First you should go through the limitations of the Failover Groups and check you are compliant.
34173-image.png

Secondly do check you tried this by all means and still get the same error. Here is document which explains it in detail.

Finally, we have previously seen this with misconfiguration in Azure Key Vault. When trying to establish geo links, there are some prechecks that occur, the operation is failing in the prechecks due to a misconfigured AKV. Please make sure AKV access is configured correctly on both the primary and secondary server. We request you to please refer the document for the same.

Please check and hope this helps.

Regards
Navtej S


image.png (36.1 KiB)
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for your info. We'll verify those items you mentioned.

0 Votes 0 ·

@ToddAi-1692

Please convey if you were able to check this and issue is resolved.

Thanks
Navtej S

0 Votes 0 ·

Hi Everyone,

Thank you for your responses. Luckily I was able to find and fix the issue. We are using some TDE customer managed key on Primary Server which was missing from secondary server.


0 Votes 0 ·