Apr 04 2022 01:16 PM
Hey all,
So let me set the scene for you. Through an audit finding, we are now looking into encrypting our SQL server backups. That in itself isn't a problem, I understand how to do that, I have been researching that and it is fairly doable in our environments. Most of our servers are in stacks based on their business need.
However, we have a few servers that are a conglomeration of databases from multiple production sources. So my question is this, if the certificates from production box A, B, and C are all properly place on the server (and this also assumes a key in the master database was created), can I restore databases from A, B, and C on Server D? Please let me know if my question makes sense and if you know the answer. I have been looking and I can't find anything on this specific use case.
Thanks in advance,
Chap