Has anyone had any expierences with encryption and log shipping/database mirroring.
I think you should always create a symetric key with a passphrase so it can be recovered, but that does really help here. If you use a password to open the key versus a certificate I think database mirroring wouldn't have an effect. However, I think certificates are nicer since you don't have to worry about having a password being passed around. If using a certificate it seems like you would have do some work once the mirroed database was brought online.
Hey twiggy, I split this into a separate thread so it didn't get buried as part of the other thread.
(sorry, I'm not sure what the answer to your question is)
Sung
|||Twiggy, you also posted this question on my blog. I answered it there. Here's a link to the post:
http://blogs.msdn.com/lcris/archive/2005/10/14/481434.aspx
Please post your questions in a single place.
Thanks
Laurentiu
