I just migrated our databases from an Azure VM to Managed Instance. I am using TDE on the MI with a customer managed key in Azure Key Vault. I am making a COPY ONLY backup nightly to blob storage so I can restore locally if needed. How do i restore these databases? I know I'm missing at least one step but I am getting this error:
Cannot find server asymmetric key with thumbprint 'X'.
RESTORE HEADERONLY is terminating abnormally.
Can someone please point me to a guide or tell me the steps for this?
Thanks
Chris