I want to add multiple master database encryption keys and certificates.
Can I do that?
closed as not constructive by marc_s, Marian, Mark Storey-Smith, Jon Seigel, RolandoMySQLDBA May 21 '13 at 16:28
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. If this question can be reworded to fit the rules in the help center, please edit the question.
From my knowledge, you cannot have multiple encryption database encryption keys as the Server stores a Server Master key automatically when SQL Server is first installed. It will use this for decryption (among other things) of database keys.
When you have created a database key (which is implicit) it will store a copy in the Master db, if you issue another create statement that will replace the existing key.
You should be creating a backup of the DMK and storing this somewhere secure, there is nothing to stop you having multiple copies of this key backup.
MSDN should tell you everything you need to know in greater detail.
you will be able to create multiple certificates for external software etc. you can generate these keys yourself or get them from external providers