Hi, this is a question both to fix the immediate issue, and gain some understanding of the security model.
As part of trying out transparent data encryption, I have backed up and restored a user database certificate on a different server without specifying a private key on either the backup or restore.
When I try to attach the encrypted database on the other server where I have restored the certificate, I get the error
" a key required by this operation appears to be corrupted "
I have checked that the certificate thumbprint matches on the source and destination servers.
So my question is - do I necessarily need to backup the certificate with a private key for this process to work? And if yes, then why is this so - what is the significance of the certificate's private key
View Complete Post